APPS.PQP_PENSION_EXTRACTS dependencies on PAY_ELEMENT_SETS

Line 3646: FROM pay_element_sets

3642:
3643: CURSOR csr_ele_set_name(c_element_set_id IN NUMBER
3644: )IS
3645: SELECT element_set_name
3646: FROM pay_element_sets
3647: WHERE element_set_id = c_element_set_id
3648: AND element_set_type = 'C';
3649:
3650: CURSOR csr_ele_name( c_element_type_id IN NUMBER

Line 3700: l_element_set pay_element_sets.element_set_name%TYPE;

3696: WHERE location_id = c_location_id;
3697:
3698: l_proc_name VARCHAR2(150) := g_proc_name ||'Set_ConcProg_Parameter_Values';
3699: l_extract_name ben_ext_dfn.NAME%TYPE;
3700: l_element_set pay_element_sets.element_set_name%TYPE;
3701: l_element_name pay_element_types_f.element_name%TYPE;
3702: l_gre_name hr_organization_units.NAME%TYPE ;
3703: l_payroll_name pay_payrolls_f.payroll_name%TYPE ;
3704: l_con_set_name pay_consolidation_sets.consolidation_set_name%TYPE;