APPS.PQP_PENSION_EXTRACTS dependencies on PER_PERSON_TYPES

Line 321: ,per_person_types ppt

317: ,pps.actual_termination_date
318: ,pps.date_start
319: ,paf.original_date_of_hire
320: FROM per_all_people_f paf
321: ,per_person_types ppt
322: ,per_periods_of_service pps
323: WHERE paf.person_id = c_person_id
324: AND ppt.person_type_id = paf.person_type_id
325: AND pps.business_group_id = g_business_group_id

Line 3689: FROM per_person_types

3685:
3686: CURSOR csr_person_type (c_person_type_id IN NUMBER
3687: )IS
3688: SELECT user_person_type
3689: FROM per_person_types
3690: WHERE person_type_id = c_person_type_id;
3691:
3692: CURSOR csr_location_code (c_location_id IN NUMBER
3693: )IS

Line 3706: l_person_type per_person_types.user_person_type%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
3709: hr_utility.set_location('Entering: '||l_proc_name, 5);
3710: OPEN csr_ext_name( c_ext_dfn_id => p_ext_dfn_id);