DBA Data[Home] [Help]

APPS.PAY_SE_ARCHIVE_CWCA dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 269: FROM per_assignment_status_types

265: AND paa.effective_end_date > = p_start_date
266: AND assignment_status_type_id
267: IN
268: (SELECT assignment_status_type_id
269: FROM per_assignment_status_types
270: WHERE per_system_status = 'ACTIVE_ASSIGN'
271: AND active_flag = 'Y'
272: AND ((legislation_code is null and business_group_id is null)
273: OR (business_group_id = p_business_group_id)