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 615: FROM per_all_assignments_f asg

611: IS
612: CURSOR c_termination_check
613: IS
614: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
615: FROM per_all_assignments_f asg
616: ,per_periods_of_service pos
617: WHERE asg.person_id = pos.person_id
618: AND asg.assignment_id = p_assignment_id
619: AND asg.business_group_id = pos.business_group_id

Line 4751: ,per_all_assignments_f paf

4747: SELECT paa.assignment_id
4748: ,paa.payroll_action_id
4749: ,paf.person_id
4750: FROM pay_assignment_actions paa
4751: ,per_all_assignments_f paf
4752: WHERE paa.assignment_action_id = p_action_context_id
4753: AND paa.assignment_id = paf.assignment_id
4754: AND ROWNUM =1;
4755:

Line 4759: FROM per_all_assignments_f asg

4755:
4756: CURSOR c_termination_check(p_assignment_id NUMBER)
4757: IS
4758: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
4759: FROM per_all_assignments_f asg
4760: ,per_periods_of_service pos
4761: WHERE asg.person_id = pos.person_id
4762: AND asg.assignment_id = p_assignment_id
4763: AND asg.business_group_id = pos.business_group_id