CREATE TABLE TMP_ROLE_PAYMENT.txt
| 1 |
CREATE TABLE TMP_ROLE_PAYMENT_SEARCH( |
|---|---|
| 2 |
ROLE_NAME VARCHAR(50) |
| 3 |
) |
| 4 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TPGD')
|
| 5 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('GDDV')
|
| 6 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PGD')
|
| 7 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PTGD')
|
| 8 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TGD')
|
| 9 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('HDQT')
|
| 10 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TP')
|
| 11 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PP')
|
| 12 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TBP')
|
| 13 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('KTT')
|
| 14 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('GDK')
|
| 15 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('KSV')
|
| 16 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TC')
|
| 17 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('NVTC')
|
| 18 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('TPTC')
|
| 19 |
INSERT TMP_ROLE_PAYMENT_SEARCH(ROLE_NAME) VALUES ('PPGD')
|
| 20 |
SELECT * FROM TMP_ROLE_PAYMENT_SEARCH |