APPS.HR_CA_PERSON_TERM_LEG_HOOK dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 42: per_assignment_status_types past

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