70: FROM dual
71: WHERE EXISTS (
72: SELECT '1'
73: FROM per_assignments_f paf, 74: per_addresses pad 75: WHERE paf.assignment_id = p_assignment_id AND
76: paf.person_id = pad.person_id AND
77: pad.date_from <= p_period_end AND
78: NVL(pad.date_to ,p_period_end) >= p_period_start AND