APPS.PAY_GB_EPS dependencies on PER_ALL_PEOPLE_F

Line 377: from per_all_people_f papf ,pay_gb_eps_details pged

373:
374:
375: cursor c_get_approver is
376: select papf.email_address email_address
377: from per_all_people_f papf ,pay_gb_eps_details pged
378: where pged.effective_date = p_effective_date
379: and pged.emp_paye_reference = p_emp_paye_reference
380: and papf.person_id = pged.approver_id
381: order by papf.effective_start_date desc;

Line 385: from per_all_people_f papf ,pay_gb_eps_details pged

381: order by papf.effective_start_date desc;
382:
383: cursor c_get_user is
384: select papf.email_address email_address
385: from per_all_people_f papf ,pay_gb_eps_details pged
386: where pged.effective_date = p_effective_date
387: and pged.emp_paye_reference = p_emp_paye_reference
388: and papf.person_id = pged.user_id
389: order by papf.effective_start_date desc;