APPS.HR_TCA_UTILITY dependencies on PER_PERSON_TYPES
Line 26: ,per_person_types typ
22: cursor person_cur (p_party_id in number) IS
23: SELECT ppf.PERSON_ID
24: ,typ.SYSTEM_PERSON_TYPE
25: FROM per_all_people_f ppf 26: ,per_person_types typ 27: ,per_person_type_usages_f ptu
28: WHERE ppf.party_id = p_party_id
29: AND l_effective_date between ppf.effective_start_date
30: and ppf.effective_end_date