APPS.SSP_SSP_PKG dependencies on PER_ALL_PEOPLE_F

Line 295: from per_all_people_f PERSON,

291: nvl (service.final_process_date,
292: hr_general.end_of_time) FINAL_PROCESS_DATE,
293: /* 7688727 End */
294: service.leaving_reason
295: from per_all_people_f PERSON,
296: per_periods_of_service SERVICE
297: where person.person_id = p_person_id
298: and service.person_id = person.person_id
299: and p_date_start between service.date_start

Line 1285: from per_all_people_f

1281: l_age number;
1282:
1283: cursor get_age is
1284: select months_between(p_date,date_of_birth)/12
1285: from per_all_people_f
1286: where person_id = p_person_id
1287: and effective_end_date = (select max(effective_end_date)
1288: from per_all_people_f
1289: where person_id = p_person_id);

Line 1288: from per_all_people_f

1284: select months_between(p_date,date_of_birth)/12
1285: from per_all_people_f
1286: where person_id = p_person_id
1287: and effective_end_date = (select max(effective_end_date)
1288: from per_all_people_f
1289: where person_id = p_person_id);
1290:
1291: cursor get_age2 is
1292: select months_between(p_date,p_date_of_birth)/12

Line 3640: from per_all_people_f ppf

3636: --
3637: -- Get current linking letter end date off the person record
3638: cursor csr_link_letter is
3639: select fnd_date.canonical_to_date(ppf.per_information11)
3640: from per_all_people_f ppf
3641: where ppf.person_id = p_absence.person_id
3642: and ppf.per_information_category = 'GB'
3643: and sysdate between ppf.effective_start_date and ppf.effective_end_date;
3644: