APPS.SSP_SSP_PKG dependencies on PER_ALL_PEOPLE_F

Line 282: from per_all_people_f PERSON,

278: hr_general.end_of_time) ACTUAL_TERMINATION_DATE,
279: nvl (service.last_standard_process_date,
280: hr_general.end_of_time) LAST_STANDARD_PROCESS_DATE,
281: service.leaving_reason
282: from per_all_people_f PERSON,
283: per_periods_of_service SERVICE
284: where person.person_id = p_person_id
285: and service.person_id = person.person_id
286: and p_date_start between service.date_start

Line 1250: from per_all_people_f

1246: l_age number;
1247:
1248: cursor get_age is
1249: select months_between(p_date,date_of_birth)/12
1250: from per_all_people_f
1251: where person_id = p_person_id
1252: and effective_end_date = (select max(effective_end_date)
1253: from per_all_people_f
1254: where person_id = p_person_id);

Line 1253: from per_all_people_f

1249: select months_between(p_date,date_of_birth)/12
1250: from per_all_people_f
1251: where person_id = p_person_id
1252: and effective_end_date = (select max(effective_end_date)
1253: from per_all_people_f
1254: where person_id = p_person_id);
1255:
1256: cursor get_age2 is
1257: select months_between(p_date,p_date_of_birth)/12

Line 3526: from per_all_people_f ppf

3522: --
3523: -- Get current linking letter end date off the person record
3524: cursor csr_link_letter is
3525: select fnd_date.canonical_to_date(ppf.per_information11)
3526: from per_all_people_f ppf
3527: where ppf.person_id = p_absence.person_id
3528: and ppf.per_information_category = 'GB'
3529: and sysdate between ppf.effective_start_date and ppf.effective_end_date;
3530: