DBA Data[Home] [Help]

APPS.PER_UTILITY_FUNCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 376: , per_assignment_status_types b

372: select a.effective_start_date
373: , a.effective_end_date
374: , b.per_system_status
375: from per_all_assignments_f a
376: , per_assignment_status_types b
377: where a.assignment_id = P_Assignment_ID
378: and a.assignment_status_type_id = b.assignment_status_type_id
379: and P_Effective_Date
380: between a.effective_start_date and a.effective_end_date;