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_ALL_ASSIGNMENTS_F

Line 215: p_asg_id IN per_all_assignments_f.assignment_id%TYPE

211: -- Returns the start and end dates of an
212: -- assignment
213: -------------------------------------------
214: CURSOR c_Assignment(
215: p_asg_id IN per_all_assignments_f.assignment_id%TYPE
216: )
217: IS
218: SELECT min(asg.effective_start_date) start_date
219: , max(asg.effective_end_date) end_date

Line 221: , per_all_assignments_f asg

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');
225: