APPS.HR_US_PERSON_TERM_LEG_HOOK dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 44: per_assignment_status_types past

40:
41: cursor c_get_assignments(p_person_id in number) is
42: select distinct assignment_id
43: from per_assignments_f paf_o,
44: per_assignment_status_types past
45: where paf_o.person_id = p_person_id
46: and paf_o.assignment_status_type_id = past.assignment_status_type_id
47: and past.per_system_status = 'TERM_ASSIGN'
48: and ((past.business_group_id is null