Line 904: or trunc(paf.effective_end_date) = hr_general.END_OF_TIME
900: and paf.person_id >= stperson
901: and paf.person_id <= endperson
902: and paf.assignment_type in ('E','C')
903: and (paf.effective_end_date >= b_end_date 904: or trunc(paf.effective_end_date) = hr_general.END_OF_TIME 905: )
906: and paf.effective_start_date <= b_start_date
907: group by
908: paf.assignment_id,