APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 335: ,per_assignment_status_types pas

331: CURSOR suspended_asg_end_dt(c_assignment_id NUMBER
332: ,c_reporting_date DATE ) IS
333: SELECT MAX(paa.effective_end_date)
334: FROM per_all_assignments_f paa
335: ,per_assignment_status_types pas
336: WHERE paa.assignment_id = c_assignment_id
337: AND pas.assignment_status_type_id = paa.assignment_status_type_id
338: AND pas.per_system_status = 'SUSP_ASSIGN'
339: AND paa.effective_end_date