DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_DPSA dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 734: from per_assignment_status_types

730: AND paa.EFFECTIVE_START_DATE <= p_end_date
731: AND paa.EFFECTIVE_END_DATE > = p_start_date
732: AND assignment_status_type_id IN
733: (select assignment_status_type_id
734: from per_assignment_status_types
735: where per_system_status = 'ACTIVE_ASSIGN'
736: and active_flag = 'Y'
737: and (( legislation_code is null
738: and business_group_id is null)