DBA Data[Home] [Help]

APPS.PAY_SE_ARCHIVE_CWCA dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 272: FROM per_assignment_status_types

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