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_PRORATE_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 220: FROM per_assignment_status_types past

216: )
217: IS
218: SELECT min(asg.effective_start_date) start_date
219: , max(asg.effective_end_date) end_date
220: FROM per_assignment_status_types past
221: , per_all_assignments_f asg
222: WHERE asg.assignment_id = p_asg_id
223: AND asg.assignment_status_type_id = past.assignment_status_type_id
224: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');