APPS.SSP_ERN_BUS dependencies on PER_ALL_PEOPLE_F

Line 31: from per_all_people_f p

27: p_effective_date in date) is
28: l_proc varchar2(72) := g_package||'Check_Person_id';
29: cursor c1 is
30: select p.rowid
31: from per_all_people_f p
32: where p.person_id = p_person_id
33: and p_effective_date between p.effective_start_date and
34: p.effective_end_date;
35: c1_rec c1%ROWTYPE;

Line 243: per_all_people_f ppf,

239: where ptp.payroll_id in
240: ( select papf.payroll_id
241: from pay_all_payrolls_f papf,
242: per_all_assignments_f paf,
243: per_all_people_f ppf,
244: per_time_periods ptp
245: where ppf.person_id = paf.person_id
246: and papf.payroll_id = paf.payroll_id
247: and paf.payroll_id = ptp.payroll_id

Line 280: per_all_people_f ppf,

276: where ptp.payroll_id in
277: ( select papf.payroll_id
278: from pay_all_payrolls_f papf,
279: per_all_assignments_f paf,
280: per_all_people_f ppf,
281: per_time_periods ptp
282: where ppf.person_id = paf.person_id
283: and papf.payroll_id = paf.payroll_id
284: and paf.payroll_id = ptp.payroll_id

Line 604: from per_all_people_f

600: procedure stop_if_a_director is
601: --
602: cursor csr_director is
603: select 1
604: from per_all_people_f
605: where per_information2 = 'Y' -- Director_flag
606: and person_id = p_person_id
607: and p_effective_date between effective_start_date
608: and effective_end_date;