APPS.PY_ZA_PRORATE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 219: p_asg_id IN per_all_assignments_f.assignment_id%TYPE

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

Line 225: , per_all_assignments_f asg

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