3859: ,c_end_date in date) IS
3860: SELECT min(asg.effective_start_date)
3861: ,max(asg.effective_end_date)
3862: FROM per_assignments_f asg
3863: ,per_assignment_status_types past
3864: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
3865: AND past.per_system_status = 'ACTIVE_ASSIGN'
3866: AND asg.effective_start_date <= trunc(c_end_date)
3867: AND nvl(asg.effective_end_date, trunc(c_end_date)) >= trunc(c_start_date)
6033: ,c_end_date in date) IS
6034: SELECT min(asg.effective_start_date)
6035: ,max(asg.effective_end_date)
6036: FROM per_assignments_f asg
6037: ,per_assignment_status_types past
6038: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
6039: AND past.per_system_status = 'ACTIVE_ASSIGN'
6040: AND asg.effective_start_date <= trunc(c_end_date)
6041: AND nvl(asg.effective_end_date, trunc(c_end_date)) >= trunc(c_start_date)
6234: ,c_end_date in date) IS
6235: SELECT min(asg.effective_start_date)
6236: ,max(asg.effective_end_date)
6237: FROM per_assignments_f asg
6238: ,per_assignment_status_types past
6239: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
6240: AND past.per_system_status = 'ACTIVE_ASSIGN'
6241: AND asg.effective_start_date <= trunc(c_end_date)
6242: AND nvl(asg.effective_end_date, trunc(c_end_date)) >= trunc(c_start_date)