DBA Data[Home] [Help]

APPS.PAY_GB_EPS_13 dependencies on PER_ALL_PEOPLE_F

Line 359: from per_all_people_f papf ,pay_gb_eps_details pged

355:
356:
357: cursor c_get_approver is
358: select papf.email_address email_address
359: from per_all_people_f papf ,pay_gb_eps_details pged
360: where pged.effective_date = p_effective_date
361: and pged.emp_paye_reference = p_emp_paye_reference
362: and papf.person_id = pged.approver_id
363: order by papf.effective_start_date desc;

Line 367: from per_all_people_f papf ,pay_gb_eps_details pged

363: order by papf.effective_start_date desc;
364:
365: cursor c_get_user is
366: select papf.email_address email_address
367: from per_all_people_f papf ,pay_gb_eps_details pged
368: where pged.effective_date = p_effective_date
369: and pged.emp_paye_reference = p_emp_paye_reference
370: and papf.person_id = pged.user_id
371: order by papf.effective_start_date desc;