DBA Data[Home] [Help]

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 =