APPS.PQP_PENSION_EXTRACTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 33: ,gre_org_id hr_all_organization_units.organization_id%TYPE

29: ,ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE
30: ,element_set_id pay_element_sets.element_set_id%TYPE
31: ,element_type_id pay_element_types_f.element_type_id%TYPE
32: ,payroll_id pay_payrolls_f.payroll_id%TYPE
33: ,gre_org_id hr_all_organization_units.organization_id%TYPE
34: ,con_set_id pay_consolidation_sets.consolidation_set_id%TYPE
35: ,selection_criteria VARCHAR2(90)
36: ,reporting_dimension VARCHAR2(90)
37: ,extract_start_date DATE

Line 39: ,org_id hr_all_organization_units.organization_id%TYPE

35: ,selection_criteria VARCHAR2(90)
36: ,reporting_dimension VARCHAR2(90)
37: ,extract_start_date DATE
38: ,extract_end_date DATE
39: ,org_id hr_all_organization_units.organization_id%TYPE
40: ,person_type_id PER_PERSON_TYPES.PERSON_TYPE_ID%TYPE
41: ,location_id hr_locations_all.location_id%TYPE
42: ,benefit_action_id ben_person_actions.benefit_action_id%TYPE
43: );

Line 142: ,org_name hr_all_organization_units.NAME%TYPE

138: ,endingdt date
139: ,grename hr_organization_units.NAME%TYPE
140: ,payrollname pay_payrolls_f.payroll_name%TYPE
141: ,consolset pay_consolidation_sets.consolidation_set_name%TYPE
142: ,org_name hr_all_organization_units.NAME%TYPE
143: ,person_type per_person_types.user_person_type%TYPE
144: ,location hr_locations_all.location_code%TYPE
145: );
146: