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 224: FROM per_assignment_status_types past

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