APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_ELEMENT_SETS

Line 4776: FROM pay_element_sets

4772:
4773: CURSOR csr_ele_set_name(c_element_set_id IN NUMBER
4774: )IS
4775: SELECT element_set_name
4776: FROM pay_element_sets
4777: WHERE element_set_id = c_element_set_id
4778: AND element_set_type = 'C';
4779:
4780: CURSOR csr_ele_name( c_element_type_id IN NUMBER

Line 4811: l_element_set PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;

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;
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;