240: from fnd_user A
241: Where A.customer_id = l_source_rec.source_id
242: and A.employee_id is not null
243: and exists ( select person_id
244: from per_workforce_current_x
245: Where person_id = A.employee_id)
246: and ( (A.end_date is null) OR (A.end_date > sysdate) );
247:
248: If l_emp_id is not null Then