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_NL_WAGE_REPORT_PKG dependencies on PER_ALL_PEOPLE_F

Line 9036: per_all_people_f papf,

9032:
9033: CURSOR csr_get_ass_bdate(c_assignment_id NUMBER) IS
9034: select papf.date_of_birth, TRUNC(MONTHS_BETWEEN(p_end_date,papf.date_of_birth)/12) Age
9035: from
9036: per_all_people_f papf,
9037: per_all_assignments_f paaf
9038: where paaf.assignment_id = c_assignment_id
9039: AND papf.person_id = paaf.person_id
9040: AND p_end_date between paaf.effective_start_date and paaf.effective_end_date

Line 9634: ,per_all_people_f pap

9630: ,paaf.assignment_status_type_id
9631: ,paaf.payroll_id
9632: ,paaf.primary_flag
9633: FROM per_all_assignments_f paaf
9634: ,per_all_people_f pap
9635: WHERE paaf.assignment_id = c_assignment_id
9636: AND paaf.person_id = pap.person_id
9637: AND c_effective_date BETWEEN paaf.effective_start_date
9638: AND paaf.effective_end_date

Line 13998: ,per_all_people_f pap

13994: ,paaf.assignment_status_type_id
13995: ,paaf.payroll_id
13996: ,paaf.primary_flag
13997: FROM per_all_assignments_f paaf
13998: ,per_all_people_f pap
13999: WHERE paaf.assignment_id = c_assignment_id
14000: AND paaf.person_id = pap.person_id
14001: AND c_effective_date BETWEEN paaf.effective_start_date
14002: AND paaf.effective_end_date