DBA Data[Home] [Help]

APPS.QA_SPECS_PUB dependencies on PO_VENDORS

Line 958: FROM po_vendors

954: l_vendor_id := qa_plan_element_api.get_supplier_id(p_supplier_name);
955: ELSE
956: -- Validate vendor
957: SELECT count(*) into l_validate_vendor
958: FROM po_vendors
959: WHERE vendor_id = p_supplier_id
960: AND nvl(end_date_active, sysdate + 1) > sysdate;
961:
962: IF l_validate_vendor = 0 THEN