780: IF (p_vendor_type_lookup_code = 'EMPLOYEE') THEN
781: BEGIN
782: SELECT papf.national_identifier
783: INTO l_tin 784: FROM per_all_people_f papf 785: WHERE person_id = p_employee_id
786: AND ROWNUM < 2;
787: EXCEPTION
788: WHEN NO_DATA_FOUND THEN