APPS.PQP_GB_PSI_BASIC_DATA dependencies on PER_ALL_PEOPLE_F

Line 21: g_person_dtl per_all_people_f%rowtype;

17: g_business_group_id NUMBER := NULL; -- IMPORTANT TO KEEP NULL
18: g_assignment_id NUMBER := NULL; -- IMPORTANT TO KEEP NULL
19:
20: g_person_id NUMBER := NULL;
21: g_person_dtl per_all_people_f%rowtype;
22: g_assignment_dtl per_all_assignments_f%rowtype;
23:
24: g_bank_detail_report_y_n VARCHAR2(2) := NULL;
25: g_bank_details_found VARCHAR2(1) := NULL;

Line 58: from per_all_people_f papf

54: ,p_effective_date DATE
55: ,p_person_id NUMBER
56: ) IS
57: select papf.original_date_of_hire
58: from per_all_people_f papf
59: where papf.person_id = p_person_id
60: and papf.business_group_id = p_business_group_id
61: and p_effective_date
62: between papf.effective_start_date and papf.effective_end_date;

Line 99: from per_all_people_f

95: where p_effective_date
96: between paaf.effective_start_date and paaf.effective_end_date
97: and person_id in
98: (select person_id
99: from per_all_people_f
100: where national_identifier = (
101: select national_identifier
102: from per_people_f
103: where person_id = p_person_id and rownum = 1));

Line 116: from PER_CONTACT_RELATIONSHIPS pcr, per_all_people_f papf

112: ,p_person_id NUMBER
113: )
114: IS
115: select papf.date_of_birth
116: from PER_CONTACT_RELATIONSHIPS pcr, per_all_people_f papf
117: where pcr.person_id = p_person_id
118: and pcr.contact_person_id = papf.person_id
119: and papf.business_group_id = p_business_group_id
120: and pcr.business_group_id = p_business_group_id