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)