DBA Data[Home] [Help]

APPS.HR_TCA_UTILITY dependencies on PER_PERSON_TYPE_USAGES_F

Line 27: ,per_person_type_usages_f ptu

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
31: AND ppf.person_id = ptu.person_id