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

Line 550: FROM per_all_assignments_f asg

546: IS
547: CURSOR c_termination_check
548: IS
549: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
550: FROM per_all_assignments_f asg
551: ,per_periods_of_service pos
552: WHERE asg.person_id = pos.person_id
553: AND asg.assignment_id = p_assignment_id
554: AND asg.business_group_id = pos.business_group_id

Line 4427: ,per_all_assignments_f paf

4423: SELECT paa.assignment_id
4424: ,paa.payroll_action_id
4425: ,paf.person_id
4426: FROM pay_assignment_actions paa
4427: ,per_all_assignments_f paf
4428: WHERE paa.assignment_action_id = p_action_context_id
4429: AND paa.assignment_id = paf.assignment_id
4430: AND ROWNUM =1;
4431:

Line 4435: FROM per_all_assignments_f asg

4431:
4432: CURSOR c_termination_check(p_assignment_id NUMBER)
4433: IS
4434: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
4435: FROM per_all_assignments_f asg
4436: ,per_periods_of_service pos
4437: WHERE asg.person_id = pos.person_id
4438: AND asg.assignment_id = p_assignment_id
4439: AND asg.business_group_id = pos.business_group_id