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'
1270: AND business_group_id IS NULL;

Line 1285: FROM pay_user_columns puc

1281:
1282:
1283: CURSOR csr_udt_location_code IS
1284: SELECT uci.rowid, uci.*
1285: FROM pay_user_columns puc
1286: ,pay_user_rows_f pur
1287: ,pay_user_column_instances_f uci
1288: WHERE -- User Column
1289: puc.user_table_id = p_udt_id