DBA Data[Home] [Help]

APPS.AP_WEB_DB_PO_INT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 64

  SELECT vendor_site_id
    INTO l_vendor_site_id
    FROM po_vendor_sites
   WHERE vendor_site_id = p_vendor_site_id
     AND SYSDATE < NVL(inactive_date, SYSDATE + 1)
     AND NVL(pay_site_flag,'N')='Y';