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 65: from per_all_people_f papf

61: ,p_effective_date DATE
62: ,p_person_id NUMBER
63: ) IS
64: select papf.original_date_of_hire
65: from per_all_people_f papf
66: where papf.person_id = p_person_id
67: and papf.business_group_id = p_business_group_id
68: and p_effective_date
69: between papf.effective_start_date and papf.effective_end_date;

Line 108: from per_all_people_f

104: between paaf.effective_start_date and paaf.effective_end_date
105: and assignment_type <> 'A' --Added for bug 7693193
106: and person_id in
107: (select person_id
108: from per_all_people_f
109: where national_identifier = (
110: select national_identifier
111: from per_people_f
112: where person_id = p_person_id and rownum = 1));

Line 125: from PER_CONTACT_RELATIONSHIPS pcr, per_all_people_f papf

121: ,p_person_id NUMBER
122: )
123: IS
124: select papf.date_of_birth
125: from PER_CONTACT_RELATIONSHIPS pcr, per_all_people_f papf
126: where pcr.person_id = p_person_id
127: and pcr.contact_person_id = papf.person_id
128: and papf.business_group_id = p_business_group_id
129: and pcr.business_group_id = p_business_group_id