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

Line 78: per_all_assignments_f asg,

74: SELECT act.assignment_action_id,
75: act.assignment_id,
76: ppp.pre_payment_id
77: FROM pay_assignment_actions act,
78: per_all_assignments_f asg,
79: pay_payroll_actions pa2,
80: pay_payroll_actions pa1,
81: pay_pre_payments ppp,
82: pay_org_payment_methods_f OPM,

Line 567: ,per_all_assignments_f paf

563: CURSOR csr_get_address(p_assignment_id number)
564: is
565: select ADDRESS_LINE1,ADDRESS_LINE2,POSTAL_CODE --,TOWN_OR_CITY
566: FROM per_addresses pad
567: ,per_all_assignments_f paf
568: ,per_all_people_f pef
569:
570: WHERE paf.assignment_id=p_assignment_id
571: and paf.person_id = pef.person_id

Line 1416: per_all_assignments_f paf,

1412: CURSOR csr_emp_no(v_asg_act_id pay_assignment_actions.assignment_action_id%TYPE)
1413: IS
1414: SELECT ppf.employee_number
1415: FROM per_all_people_f ppf,
1416: per_all_assignments_f paf,
1417: pay_assignment_actions paa
1418: WHERE ppf.person_id=paf.person_id
1419: AND paf.assignment_id=paa.assignment_id
1420: AND paa.assignment_action_id=v_asg_act_id;