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 1235: from pay_user_columns

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

Line 1276: l_user_column_name pay_user_columns.user_column_name%TYPE;

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

Line 1280: l_user_column_id pay_user_columns.user_column_id%TYPE;

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

Line 1751: ,pay_user_columns puc

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

Line 5778: ,pay_user_columns asgc

5774: ,c_business_group_id in number
5775: ,c_legislation_code in varchar2) Is
5776: Select extv.value,extv.business_group_id
5777: From pay_user_tables tbls
5778: ,pay_user_columns asgc
5779: ,pay_user_columns extc
5780: ,pay_user_rows_f urws
5781: ,pay_user_column_instances_f asgv
5782: ,pay_user_column_instances_f extv

Line 5779: ,pay_user_columns extc

5775: ,c_legislation_code in varchar2) Is
5776: Select extv.value,extv.business_group_id
5777: From pay_user_tables tbls
5778: ,pay_user_columns asgc
5779: ,pay_user_columns extc
5780: ,pay_user_rows_f urws
5781: ,pay_user_column_instances_f asgv
5782: ,pay_user_column_instances_f extv
5783: where tbls.user_table_name ='PQP_GB_TP_EMPLOYMENT_CATEGORY_TRANSALATION_TABLE'