DBA Data[Home] [Help]

APPS.HR_CHANGE_START_DATE_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 734: from per_person_type_usages_f ptu,

730: ,p_old_start_date DATE) is
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