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_PERIODS_OF_SERVICE

Line 252: ,per_periods_of_service pos

248: CURSOR c_termination_check
249: IS
250: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
251: FROM per_all_assignments_f asg
252: ,per_periods_of_service pos
253: WHERE asg.person_id = pos.person_id
254: AND asg.assignment_id = p_assignment_id
255: AND asg.business_group_id = pos.business_group_id
256: AND asg.business_group_id = g_bg_id

Line 2821: ,per_periods_of_service pos

2817: CURSOR c_termination_check(p_assignment_id NUMBER)
2818: IS
2819: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
2820: FROM per_all_assignments_f asg
2821: ,per_periods_of_service pos
2822: WHERE asg.person_id = pos.person_id
2823: AND asg.assignment_id = p_assignment_id
2824: AND asg.business_group_id = pos.business_group_id
2825: AND asg.business_group_id = g_bg_id