DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1094: from per_assignment_status_types

1090: -- AND paa.EFFECTIVE_START_DATE <= p_end_date 10322958
1091: AND paa.EFFECTIVE_END_DATE > = p_start_date
1092: AND assignment_status_type_id IN
1093: (select assignment_status_type_id
1094: from per_assignment_status_types
1095: where per_system_status = 'ACTIVE_ASSIGN'
1096: and active_flag = 'Y'
1097: and (( legislation_code is null
1098: and business_group_id is null)