APPS.PER_PERIODS_OF_SERVICE_PKG_V2 dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 526: , per_assignment_status_types past

522: (p_person_id per_all_people_f.person_id%TYPE)
523: IS
524: SELECT min(effective_start_date) + 1
525: FROM per_all_assignments_f paf
526: , per_assignment_status_types past
527: WHERE person_id = p_person_id
528: AND paf.assignment_status_type_id = past.assignment_status_type_id
529: AND past.per_system_status = 'ACCEPTED';
530: BEGIN