APPS.PQP_PENSION_EXTRACTS dependencies on PAY_CONSOLIDATION_SETS

Line 3677: FROM pay_consolidation_sets con

3673:
3674: CURSOR csr_con_set (c_con_set IN NUMBER
3675: )IS
3676: SELECT con.consolidation_set_name
3677: FROM pay_consolidation_sets con
3678: WHERE con.consolidation_set_id = c_con_set;
3679:
3680: CURSOR csr_org_name (c_org_id IN NUMBER
3681: )IS

Line 3704: l_con_set_name pay_consolidation_sets.consolidation_set_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;
3705: l_org_name hr_all_organization_units.NAME%TYPE;
3706: l_person_type per_person_types.user_person_type%TYPE;
3707: l_location hr_locations_all.location_code%TYPE;
3708: BEGIN