DBA Data[Home] [Help]

APPS.PQP_GB_TP_EXT_PROCESS dependencies on PAY_USER_COLUMNS

Line 1266: FROM pay_user_columns

1262: c_effective_date CONSTANT DATE := to_date('01/01/1951','dd/mm/yyyy');
1263:
1264: CURSOR csr_user_col IS
1265: SELECT user_column_id
1266: FROM pay_user_columns
1267: WHERE user_table_id = p_udt_id
1268: AND user_column_name = 'Location Code'
1269: -- AND legislation_code = 'GB' -- Commented out for the bug 9963239
1270: -- AND business_group_id IS NULL; -- Commented out for the bug 9963239

Line 1291: FROM pay_user_columns puc

1287:
1288:
1289: CURSOR csr_udt_location_code IS
1290: SELECT uci.rowid, uci.*
1291: FROM pay_user_columns puc
1292: ,pay_user_rows_f pur
1293: ,pay_user_column_instances_f uci
1294: WHERE -- User Column
1295: puc.user_table_id = p_udt_id