APPS.HR_CHANGE_START_DATE_API dependencies on PER_PERSON_TYPES

Line 735: per_person_types pt

731: cursor csr_person_type_change is
732: select 'x' from dual where exists
733: (select 1
734: from per_person_type_usages_f ptu,
735: per_person_types pt
736: where ptu.person_id = p_person_id
737: and ptu.effective_start_date <> p_old_start_date
738: and ptu.effective_start_date between p_earlier_date and p_later_date
739: and ptu.person_type_id = pt.person_type_id

Line 2041: l_system_person_type per_person_types.system_person_type%TYPE;

2037: l_old_start_date DATE;
2038: l_new_start_date DATE;
2039: l_earlier_date DATE;
2040: l_later_date DATE;
2041: l_system_person_type per_person_types.system_person_type%TYPE;
2042: l_warn_ee varchar2(1) := 'N';
2043: --
2044: begin
2045: hr_utility.set_location('Entering:'|| l_proc, 10);