DBA Data[Home] [Help]

APPS.PER_UTILITY_FUNCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 280: , per_assignment_status_types b

276: select a.effective_start_date
277: , a.effective_end_date
278: , b.per_system_status
279: from per_all_assignments_f a
280: , per_assignment_status_types b
281: where a.assignment_id = P_Assignment_ID
282: and a.assignment_status_type_id = b.assignment_status_type_id
283: and P_Effective_Date
284: between a.effective_start_date and a.effective_end_date;