APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_USER_ROWS_F

Line 1247: from pay_user_rows_f

1243:
1244: Cursor Get_Row_Name ( c_user_table_id in number
1245: ,c_effective_date in date ) Is
1246: Select user_row_id, row_low_range_or_name
1247: from pay_user_rows_f
1248: where user_table_id = c_user_table_id
1249: and trunc(c_effective_date) between effective_start_date
1250: and effective_end_date
1251: and ((business_group_id is null and legislation_code is null)

Line 1276: l_user_row_name pay_user_rows_f.row_low_range_or_name%TYPE;

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;
1280: l_user_row_id pay_user_rows_f.user_row_id%TYPE;

Line 1280: l_user_row_id pay_user_rows_f.user_row_id%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:
1284: Begin

Line 1751: ,pay_user_rows_f pur

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
1755: and puc.user_column_name = c_user_column_name

Line 5808: ,pay_user_rows_f urws

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'
5812: and asgc.user_table_id = tbls.user_table_id

Line 17443: FROM pay_user_rows_f

17439:
17440: CURSOR csr_get_lon_user_rows (c_udt_id NUMBER)
17441: IS
17442: SELECT row_low_range_or_name
17443: FROM pay_user_rows_f
17444: WHERE user_table_id = c_udt_id
17445: AND p_effective_date BETWEEN effective_start_date
17446: AND effective_end_date
17447: AND row_low_range_or_name in ('LARP Inner Allowance','LARP Outer Allowance',

Line 17455: FROM pay_user_rows_f

17451:
17452: CURSOR csr_get_spl_user_rows (c_udt_id NUMBER)
17453: IS
17454: SELECT row_low_range_or_name
17455: FROM pay_user_rows_f
17456: WHERE user_table_id = c_udt_id
17457: AND p_effective_date BETWEEN effective_start_date
17458: AND effective_end_date
17459: AND row_low_range_or_name in ('SPAP Lower Rate','SPAP Higher Rate',

Line 17474: l_user_row_name pay_user_rows_f.row_low_range_or_name%TYPE;

17470:
17471: -- 115.49 : TLR
17472: l_tab_tlr_aln_eles t_allowance_eles;
17473:
17474: l_user_row_name pay_user_rows_f.row_low_range_or_name%TYPE;
17475: l_udt_name pay_user_tables.user_table_name%TYPE :=
17476: 'PQP_GB_TP_TYPE1_EXTRACT_DEFINITIONS';
17477: l_return NUMBER;
17478: l_udt_id NUMBER;