[Home] [Help]
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)