eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_USER_COLUMNS

Line 1234: from pay_user_columns

1230: );
1231:
1232: Cursor Get_Col_Name ( c_user_table_id in number ) Is
1233: Select user_column_id, user_column_name
1234: from pay_user_columns
1235: where user_table_id = c_user_table_id
1236: and ((business_group_id is null and legislation_code is null)
1237: or (legislation_code is not null
1238: and legislation_code = 'GB')

Line 1275: l_user_column_name pay_user_columns.user_column_name%TYPE;

1271:
1272: -- Comment this out as this is not needed as a local collection
1273: -- This has been declared in the pkg header as global collection
1274: -- g_udt_rec t_udt_array;
1275: l_user_column_name pay_user_columns.user_column_name%TYPE;
1276: l_user_row_name pay_user_rows_f.row_low_range_or_name%TYPE;
1277: l_matrix_value pay_user_column_instances_f.value%TYPE;
1278: l_user_table_id pay_user_tables.user_table_id%TYPE;
1279: l_user_column_id pay_user_columns.user_column_id%TYPE;

Line 1279: l_user_column_id pay_user_columns.user_column_id%TYPE;

1275: l_user_column_name pay_user_columns.user_column_name%TYPE;
1276: l_user_row_name pay_user_rows_f.row_low_range_or_name%TYPE;
1277: l_matrix_value pay_user_column_instances_f.value%TYPE;
1278: l_user_table_id pay_user_tables.user_table_id%TYPE;
1279: l_user_column_id pay_user_columns.user_column_id%TYPE;
1280: l_user_row_id pay_user_rows_f.user_row_id%TYPE;
1281: l_idx number;
1282: l_proc_name varchar2(60) := g_proc_name || 'get_udt_data';
1283:

Line 1750: ,pay_user_columns puc

1746: ,puc.user_column_name
1747: ,pur.row_low_range_or_name
1748: ,pci.value
1749: from pay_user_tables put
1750: ,pay_user_columns puc
1751: ,pay_user_rows_f pur
1752: ,pay_user_column_instances_f pci
1753: where put.user_table_name = c_user_table_name
1754: and puc.user_table_id = put.user_table_id

Line 5806: ,pay_user_columns asgc

5802: ,c_business_group_id in number
5803: ,c_legislation_code in varchar2) Is
5804: Select extv.value,extv.business_group_id
5805: From pay_user_tables tbls
5806: ,pay_user_columns asgc
5807: ,pay_user_columns extc
5808: ,pay_user_rows_f urws
5809: ,pay_user_column_instances_f asgv
5810: ,pay_user_column_instances_f extv

Line 5807: ,pay_user_columns extc

5803: ,c_legislation_code in varchar2) Is
5804: Select extv.value,extv.business_group_id
5805: From pay_user_tables tbls
5806: ,pay_user_columns asgc
5807: ,pay_user_columns extc
5808: ,pay_user_rows_f urws
5809: ,pay_user_column_instances_f asgv
5810: ,pay_user_column_instances_f extv
5811: where tbls.user_table_name ='PQP_GB_TP_EMPLOYMENT_CATEGORY_TRANSALATION_TABLE'