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_IE_WNU_EDI dependencies on PER_ALL_ASSIGNMENTS_F

Line 28: per_all_assignments_f aaf

24: --
25: cursor csr_employee is
26: select upper(apf.current_employee_flag)
27: from per_all_people_f apf,
28: per_all_assignments_f aaf
29: where aaf.person_id = apf.person_id
30: and aaf.assignment_id = p_assignment_id
31: and p_effective_date between
32: apf.effective_start_date and apf.effective_end_date

Line 162: from per_all_assignments_f asg,

158:
159: cursor csr_state(p_payroll_id NUMBER, p_emp_ref VARCHAR2, p_assignment_set_id NUMBER) IS
160: select asg.assignment_id assignment_id,
161: ppa.effective_date effective_date
162: from per_all_assignments_f asg,
163: pay_payroll_actions ppa,
164: per_all_people_f pap,
165: per_periods_of_service serv,
166: -- hr_organization_information hoi,

Line 321: from per_all_assignments_f asg,

317:
318: cursor csr_state(p_payroll_id NUMBER, p_emp_ref VARCHAR2, p_assignment_set_id NUMBER) is
319: select asg.assignment_id assignment_id,
320: ppa.effective_date effective_date
321: from per_all_assignments_f asg,
322: pay_payroll_actions ppa,
323: per_all_people_f pap,
324: per_periods_of_service serv,
325: per_assignment_extra_info aei,