667: END IF;
668: BEGIN
669: SELECT email_address
670: INTO l_approver_email
671: FROM per_all_people_f
672: WHERE person_id = l_approversOut(i).person_id
673: AND sysdate BETWEEN effective_start_date AND effective_end_date;
674: EXCEPTION
675: WHEN NO_DATA_FOUND THEN