DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_CONSOLIDATION_SETS

Line 2266: FROM pay_consolidation_sets con

2262:
2263: CURSOR csr_con_set (c_con_set IN Number
2264: )IS
2265: SELECT con.consolidation_set_name
2266: FROM pay_consolidation_sets con
2267: WHERE con.consolidation_set_id = c_con_set;
2268:
2269:
2270: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';

Line 2273: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;

2269:
2270: l_proc_name Varchar2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
2271: l_extract_name ben_ext_dfn.NAME%TYPE;
2272: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
2273: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
2274: l_org_name hr_all_organization_units.NAME%TYPE;
2275:
2276:
2277: BEGIN