APPS.JA_JAINOTDS_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      VENDOR_NAME
    INTO VEN_NAME
    FROM
      PO_VENDORS
    WHERE VENDOR_ID = CF_VENDOR_NAMEFORMULA0009.VENDOR_ID;

Line: 21

    SELECT
      VENDOR_SITE_CODE
    INTO SITE_NAME
    FROM
      PO_VENDOR_SITES_ALL
    WHERE VENDOR_SITE_ID = CF_VENDOR_SITEFORMULA.VENDOR_SITE_ID;

Line: 41

      SELECT
        VENDOR_NAME
      INTO VEN_NAME
      FROM
        PO_VENDORS
      WHERE VENDOR_ID = VENDOR_ID1;

Line: 62

      SELECT
        VENDOR_SITE_CODE
      INTO SITE_NAME
      FROM
        PO_VENDOR_SITES_ALL
      WHERE VENDOR_SITE_ID = VENDOR_SITE_ID1;

Line: 84

      SELECT
        TDS_SECTION
      INTO V_TDS_SECTION
      FROM
        JAI_AP_TDS_INVOICES
      WHERE INVOICE_ID = CF_TDS_SECTIONFORMULA.INVOICE_ID
        AND TDS_INVOICE_NUM = INVOICE_NUM1;

Line: 107

      SELECT
        TDS_TAX_RATE
      INTO V_TDS_RATE
      FROM
        JAI_AP_TDS_INVOICES
      WHERE INVOICE_ID = CF_TDS_TAX_RATEFORMULA.INVOICE_ID
        AND TDS_INVOICE_NUM = INVOICE_NUM1;

Line: 131

      SELECT
        TDS_TAX_ID
      INTO V_TDS_TAX_ID
      FROM
        JAI_AP_TDS_INVOICES
      WHERE INVOICE_ID = CF_TAX_NAMEFORMULA.INVOICE_ID
        AND TDS_INVOICE_NUM = INVOICE_NUM1;

Line: 138

      SELECT
        TAX_NAME
      INTO V_TDS_TAX_NAME
      FROM
        JAI_CMN_TAXES_ALL
      WHERE TAX_ID = V_TDS_TAX_ID;

Line: 153

      SELECT
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;