APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PAY_CONSOLIDATION_SETS

Line 330: FROM pay_consolidation_sets con

326:
327: CURSOR csr_con_set (c_con_set IN Number
328: )IS
329: SELECT con.consolidation_set_name
330: FROM pay_consolidation_sets con
331: WHERE con.consolidation_set_id = c_con_set;
332:
333: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
334: l_extract_name ben_ext_dfn.NAME%TYPE;

Line 336: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;

332:
333: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
334: l_extract_name ben_ext_dfn.NAME%TYPE;
335: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
336: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
337: l_org_name hr_all_organization_units.NAME%TYPE;
338:
339: BEGIN
340: Hr_Utility.set_location('Entering: '||l_proc_name, 5);