APPS.HR_EX_EMPLOYEE_API dependencies on PER_PERSON_TYPES

Line 641: l_system_person_type per_person_types.system_person_type%TYPE;

637: l_person_type_id per_all_people_f.person_type_id%TYPE;
638: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
639: l_proc varchar2(72)
640: := g_package || 'actual_termination_emp';
641: l_system_person_type per_person_types.system_person_type%TYPE;
642: l_system_person_type1 per_person_types.system_person_type%TYPE;
643: l_per_effective_start_date per_people_f.effective_start_date%TYPE;
644: l_datetrack_mode varchar2(30);
645: l_validation_start_date date;

Line 642: l_system_person_type1 per_person_types.system_person_type%TYPE;

638: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
639: l_proc varchar2(72)
640: := g_package || 'actual_termination_emp';
641: l_system_person_type per_person_types.system_person_type%TYPE;
642: l_system_person_type1 per_person_types.system_person_type%TYPE;
643: l_per_effective_start_date per_people_f.effective_start_date%TYPE;
644: l_datetrack_mode varchar2(30);
645: l_validation_start_date date;
646: l_validation_end_date date;

Line 688: , per_person_types pet

684: , pds.last_standard_process_date
685: from per_all_people_f per
686: , per_business_groups bus
687: , per_periods_of_service pds
688: , per_person_types pet
689: where pds.period_of_service_id = p_period_of_service_id
690: and bus.business_group_id = pds.business_group_id
691: and per.person_id = pds.person_id
692: and l_actual_termination_date between per.effective_start_date

Line 1925: , per_person_types pet

1921: cursor csr_valid_ex_emp is
1922: select null
1923: from per_all_people_f per
1924: , per_person_type_usages_f ptu
1925: , per_person_types pet
1926: where per.person_id = l_person_id
1927: and l_exemppet_eff_date between per.effective_start_date
1928: and per.effective_end_date
1929: and per.person_id = ptu.person_id