APPS.HR_CHANGE_START_DATE_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 29: from per_assignment_status_types past

25: and paf.effective_end_date >= p_old_start_date
26: -- start changes for bug 9304366
27: and not exists (
28: select 1
29: from per_assignment_status_types past
30: where past.assignment_status_type_id = paf.assignment_status_type_id
31: and past.per_system_status = 'TERM_ASSIGN'
32: and (past.business_group_id = paf.business_group_id
33: or past.business_group_id is NULL));