APPS.HR_TCA_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 25: FROM per_all_people_f ppf

21: --
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

Line 54: FROM per_all_people_f ppf

50: -- identifies if more than one match exists for the given party_id
51: --
52: cursor multiple_person_cur (p_party_id in number,p_person_id in number) IS
53: SELECT ppf.PERSON_ID
54: FROM per_all_people_f ppf
55: WHERE ppf.party_id = p_party_id
56: AND l_effective_date between ppf.effective_start_date
57: and ppf.effective_end_date
58: AND ppf.person_id <> p_person_id;