DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 903: from per_assignment_status_types

899: AND paa.EFFECTIVE_START_DATE <= p_end_date
900: AND paa.EFFECTIVE_END_DATE > = p_start_date
901: AND assignment_status_type_id IN
902: (select assignment_status_type_id
903: from per_assignment_status_types
904: where per_system_status = 'ACTIVE_ASSIGN'
905: and active_flag = 'Y'
906: and (( legislation_code is null
907: and business_group_id is null)