APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on PER_ALL_PEOPLE_F

Line 2342: -- per_all_people_f

2338:
2339: --End of GSP changes
2340:
2341: -- cursor to get the applicant object_version_number from
2342: -- per_all_people_f
2343: cursor per_applicant_rec(p_appl_person_id in number,
2344: p_appl_effective_date in date) is
2345: select object_version_number
2346: from per_all_people_f

Line 2346: from per_all_people_f

2342: -- per_all_people_f
2343: cursor per_applicant_rec(p_appl_person_id in number,
2344: p_appl_effective_date in date) is
2345: select object_version_number
2346: from per_all_people_f
2347: where person_id = p_appl_person_id
2348: and p_appl_effective_date between effective_start_date
2349: and effective_end_date;
2350:

Line 4400: -- per_all_people_f

4396: if(l_db_assignment_rec.assignment_type = 'A' AND (l_asgn_change_mode is null OR
4397: l_asgn_change_mode = 'N' OR l_asgn_change_mode = 'Y') ) then
4398: g_applicant_hire := true;
4399: -- first get the object_version_number for the applicant from
4400: -- per_all_people_f
4401: open per_applicant_rec(l_old_assignment_rec.person_id, l_effective_date);
4402: fetch per_applicant_rec into l_per_object_version_number;
4403: close per_applicant_rec;
4404:

Line 6078: from per_all_people_f

6074:
6075: cursor per_applicant_rec(p_appl_person_id in number,
6076: p_appl_effective_date in date) is
6077: select object_version_number
6078: from per_all_people_f
6079: where person_id = p_appl_person_id
6080: and p_appl_effective_date between effective_start_date
6081: and effective_end_date;
6082: