APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on XMLSEQUENCE

Line 961: FROM TABLE (XMLSEQUENCE (EXTRACT (l_result_xml,'*//results/results'))) a ;

957: EXTRACTVALUE (VALUE (a), '*/first') first,
958: EXTRACTVALUE (VALUE (a), '*/last') last,
959: EXTRACTVALUE (VALUE (a), '*/middle') middle,
960: EXTRACTVALUE (VALUE (a), '*/name') name
961: FROM TABLE (XMLSEQUENCE (EXTRACT (l_result_xml,'*//results/results'))) a ;
962:
963: CURSOR c_get_vendor_site_details(p_id VARCHAR2) IS
964: SELECT CITY,COUNTRY,vdr.DUNS_NUMBER,PROVINCE,STATE,ADDRESS_LINE1,ADDRESS_LINE2,ZIP,SUPPLIER_NAME
965: FROM po_vendor_eligibility vdr, po_vendor_sites_all site