APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on PER_ALL_PEOPLE_F

Line 2340: -- per_all_people_f

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

Line 2344: from per_all_people_f

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

Line 4262: -- per_all_people_f

4258:
4259: if(l_db_assignment_rec.assignment_type = 'A') then
4260: g_applicant_hire := true;
4261: -- first get the object_version_number for the applicant from
4262: -- per_all_people_f
4263: open per_applicant_rec(l_old_assignment_rec.person_id, l_effective_date);
4264: fetch per_applicant_rec into l_per_object_version_number;
4265: close per_applicant_rec;
4266: