DBA Data[Home] [Help]

APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_CONSOLIDATION_SETS

Line 4807: FROM pay_consolidation_sets con

4803:
4804: CURSOR csr_con_set (c_con_set IN NUMBER
4805: )IS
4806: SELECT con.consolidation_set_name
4807: FROM pay_consolidation_sets con
4808: WHERE con.consolidation_set_id = c_con_set;
4809: l_proc_name VARCHAR2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
4810: l_extract_name ben_ext_dfn.NAME%TYPE;
4811: l_element_set PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;

Line 4815: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;

4811: l_element_set PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;
4812: l_element_name pay_element_types_f.element_name%TYPE;
4813: l_gre_name hr_organization_units.NAME%TYPE ;
4814: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE ;
4815: l_con_set_name PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_NAME%TYPE;
4816:
4817: BEGIN
4818: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
4819: