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.PY_ZA_TX dependencies on PER_ASSIGNMENTS_F

Line 653: FROM per_assignments_f per,

649: l_max_end_date DATE;
650:
651: cursor c1 (c_assignment_id NUMBER) is
652: SELECT per.effective_start_date, per.effective_end_date
653: FROM per_assignments_f per,
654: fnd_sessions fnd
655: WHERE per.assignment_id = c_assignment_id
656: AND fnd.effective_date BETWEEN per.effective_start_date AND per.effective_end_date
657: AND fnd.session_id = USERENV('sessionid');

Line 754: FROM per_assignments_f per,

750: l_min_start_date DATE;
751:
752: cursor c1 (c_assignment_id NUMBER) is
753: SELECT per.effective_start_date
754: FROM per_assignments_f per,
755: fnd_sessions fnd
756: WHERE per.assignment_id = c_assignment_id
757: AND fnd.effective_date BETWEEN per.effective_start_date AND per.effective_end_date
758: AND fnd.session_id = USERENV('sessionid');