APPS.PQP_PENSION_EXTRACTS dependencies on PER_PERSON_TYPES

Line 40: ,person_type_id PER_PERSON_TYPES.PERSON_TYPE_ID%TYPE

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: );
44: TYPE t_extract_params IS TABLE OF extract_params INDEX BY BINARY_INTEGER;

Line 143: ,person_type per_person_types.user_person_type%TYPE

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:
147: TYPE t_conc_prog_details IS TABLE OF conc_prog_details INDEX BY binary_integer;