APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_CONSOLIDATION_SETS

Line 2245: FROM pay_consolidation_sets con

2241:
2242: CURSOR csr_con_set (c_con_set IN Number
2243: )IS
2244: SELECT con.consolidation_set_name
2245: FROM pay_consolidation_sets con
2246: WHERE con.consolidation_set_id = c_con_set;
2247:
2248:
2249: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';

Line 2252: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;

2248:
2249: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
2250: l_extract_name ben_ext_dfn.NAME%TYPE;
2251: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
2252: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
2253: l_org_name hr_all_organization_units.NAME%TYPE;
2254:
2255:
2256: BEGIN