APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PAY_USER_TABLES

Line 311: FROM pay_user_tables tbls

307: l_proc_name VARCHAR2(61):= 'get_translate_asg_emp_cat_code';
308: l_udt_value VARCHAR2(1):= '?';
309: CURSOR csr_get_emp_cat_code (p_effective_date DATE) IS
310: SELECT extv.value
311: FROM pay_user_tables tbls
312: ,pay_user_columns asgc
313: ,pay_user_columns extc
314: ,pay_user_rows_f urws
315: ,pay_user_column_instances_f asgv

Line 572: FROM pay_user_tables

568: -- Cursor to get user_table_id
569: CURSOR csr_get_udt_id
570: IS
571: SELECT user_table_id
572: FROM pay_user_tables
573: WHERE user_table_name = p_udt_name
574: AND ( ( business_group_id IS NULL
575: AND legislation_code = g_legislation_code
576: )

Line 907: l_udt_name pay_user_tables.user_table_name%TYPE :=

903: -- 115.49 : TLR
904: l_tab_tlr_aln_eles t_allowance_eles;
905:
906: l_user_row_name pay_user_rows_f.row_low_range_or_name%TYPE;
907: l_udt_name pay_user_tables.user_table_name%TYPE :=
908: 'PQP_GB_TP_ALLOWANCE_ELEMENTS_MAPPING_TABLE';
909: l_return NUMBER;
910: l_udt_id NUMBER;
911: l_user_value pay_user_column_instances_f.value%TYPE;

Line 1279: l_udt_id pay_user_tables.user_table_id%TYPE;

1275: l_tp1_nested_level NUMBER ;
1276: l_request_id NUMBER ;
1277: l_conc_prog_name VARCHAR2(30);
1278:
1279: l_udt_id pay_user_tables.user_table_id%TYPE;
1280: l_lea_details csr_lea_details%ROWTYPE;
1281: l_lea_details_1 csr_lea_details%ROWTYPE; -- Added for checking if
1282: -- there are multiple LEA's with same LEA number
1283: l_lea_dets_by_loc csr_lea_details_by_loc%ROWTYPE;