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