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_IN_EOY_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 438: FROM per_assignments_f paf

434: /*Changed for Bug 4768371*/
435: CURSOR c_process_assignments
436: IS
437: SELECT paf.assignment_id assignment_id
438: FROM per_assignments_f paf
439: ,pay_payroll_actions ppa
440: ,pay_assignment_actions paa
441: WHERE paf.business_group_id = g_bg_id
442: AND paf.person_id BETWEEN p_start_person AND p_end_person

Line 596: ,per_assignments_f asg

592: CURSOR c_pos
593: IS
594: SELECT nvl(pos.name,job.name) name, job.name job
595: FROM per_all_positions pos
596: ,per_assignments_f asg
597: ,per_jobs job
598: WHERE asg.position_id=pos.position_id(+)
599: AND asg.job_id=job.job_id(+)
600: AND asg.assignment_id = p_assignment_id

Line 2478: ,per_assignments_f asg

2474: CURSOR c_pos(p_person_id NUMBER)
2475: IS
2476: SELECT nvl(pos.name,job.name) name ,job.name job
2477: FROM per_all_positions pos
2478: ,per_assignments_f asg
2479: ,per_jobs job
2480: WHERE asg.position_id=pos.position_id(+)
2481: AND asg.job_id=job.job_id(+)
2482: AND asg.person_id = p_person_id

Line 2762: ,per_assignments_f paf

2758: IS
2759: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
2760: FROM pay_assignment_actions paa
2761: ,pay_payroll_actions ppa
2762: ,per_assignments_f paf
2763: WHERE paf.assignment_id = paa.assignment_id
2764: AND paf.assignment_id = p_assignment_id
2765: AND paa.tax_unit_id = p_tax_unit_id
2766: AND paa.payroll_action_id = ppa.payroll_action_id