APPS.HR_CHANGE_START_DATE_API dependencies on PER_PERSON_TYPES

Line 832: from per_person_type_usages_f ptu, per_person_types ppt

828: and p.person_id = p_person_id
829: -- Start changes for bug 9304366
830: and exists (
831: select 1
832: from per_person_type_usages_f ptu, per_person_types ppt
833: where ptu.person_type_id = ppt.person_type_id
834: and ppt.system_person_type = 'APL'
835: and ptu.person_id = p.person_id
836: and ptu.effective_start_date = p_old_start_date

Line 870: per_person_types pt

866: cursor csr_person_type_change is
867: select 'x' from dual where exists
868: (select 1
869: from per_person_type_usages_f ptu,
870: per_person_types pt
871: where ptu.person_id = p_person_id
872: and ptu.effective_start_date <> p_old_start_date
873: and ptu.effective_start_date between p_earlier_date and p_later_date
874: and ptu.person_type_id = pt.person_type_id

Line 2491: l_system_person_type per_person_types.system_person_type%TYPE;

2487: l_old_start_date DATE;
2488: l_new_start_date DATE;
2489: l_earlier_date DATE;
2490: l_later_date DATE;
2491: l_system_person_type per_person_types.system_person_type%TYPE;
2492: l_warn_ee varchar2(1) := 'N';
2493: --
2494: begin
2495: hr_utility.set_location('Entering:'|| l_proc, 10);