APPS.PER_VIEWS_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 1186: per_assignment_status_types b
1182: select a.effective_start_date,
1183: a.effective_end_date,
1184: b.PER_SYSTEM_STATUS
1185: from per_assignments_f a, 1186: per_assignment_status_types b 1187: where a.assignment_id = P_assignment_id
1188: and a.effective_end_date between p_first_p_start_date and
1189: hr_general.end_of_time
1190: and a.ASSIGNMENT_STATUS_TYPE_ID =