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_PERIODS_OF_SERVICE

Line 551: ,per_periods_of_service pos

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
555: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 4436: ,per_periods_of_service pos

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
4440: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')