eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_YEER_PKG dependencies on PER_ALL_PEOPLE_F

Line 2938: per_all_people_f ppf

2934: paa.serial_number person_id,
2935: paa.action_status
2936: from pay_assignment_actions paa,
2937: pay_payroll_actions ppa,
2938: per_all_people_f ppf
2939: where paa.payroll_action_id = cp_pactid
2940: and ppa.payroll_action_id = paa.payroll_action_id
2941: and ppa.business_group_id = fp_b_g_id
2942: and not exists

Line 2978: from per_all_people_f ppf

2974: cursor cur_rl_dob ( cp_person_id in number,
2975: cp_effective_date in date ) is
2976: select ppf.date_of_birth,
2977: ppf.original_date_of_hire
2978: from per_all_people_f ppf
2979: where ppf.person_id = cp_person_id
2980: and cp_effective_date between ppf.effective_start_date
2981: and ppf.effective_end_date;
2982:

Line 3396: per_all_people_f ppf

3392: paa.action_status,
3393: ppf.last_name,ppf.first_name,ppf.middle_names
3394: from pay_assignment_actions paa,
3395: pay_payroll_actions ppa,
3396: per_all_people_f ppf
3397: where paa.payroll_action_id = cp_pactid
3398: and ppa.payroll_action_id = paa.payroll_action_id
3399: and ppa.business_group_id = fp_b_g_id
3400: and not exists

Line 3439: from per_all_people_f ppf

3435: cursor cur_dob ( cp_person_id in number,
3436: cp_effective_date in date ) is
3437: select ppf.date_of_birth,
3438: ppf.original_date_of_hire
3439: from per_all_people_f ppf
3440: where ppf.person_id = cp_person_id
3441: and cp_effective_date between ppf.effective_start_date
3442: and ppf.effective_end_date;
3443: