APPS.JA_JAINPROS_XMLP_PKG SQL Statements

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

Line: 41

      SELECT
        NAME,
        INTERNAL_ADDRESS_LINE
      FROM
        HR_ALL_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 58

      SELECT
        LOCATION_CODE
      FROM
        HR_LOCATIONS
      WHERE LOCATION_ID = P_LOCATION_ID;

Line: 89

      SELECT
        CST_REG_NO,
        ST_REG_NO,
        VAT_REG_NO
      FROM
        JAI_CMN_VENDOR_SITES
      WHERE VENDOR_ID = P_VENDOR_ID
        AND VENDOR_SITE_ID = P_VENDOR_SITE_ID;

Line: 108

      SELECT
        VENDOR_NAME
      FROM
        PO_VENDORS
      WHERE VENDOR_ID = P_VENDOR_ID;

Line: 124

      SELECT
        VENDOR_SITE_CODE,
        STATE
      FROM
        PO_VENDOR_SITES_ALL
      WHERE VENDOR_SITE_ID = P_VENDOR_SITE_ID;

Line: 142

      SELECT
        CST_REG_NO,
        ST_REG_NO,
        VAT_REG_NO
      FROM
        JAI_CMN_VENDOR_SITES
      WHERE VENDOR_ID = P_VENDOR_ID
        AND VENDOR_SITE_ID = P_VENDOR_SITE_ID;

Line: 187

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

Line: 197

      SELECT
        A.SID,
        A.SERIAL#,
        NVL(B.SPID
           ,'')
      FROM
        V$SESSION A,
        V$PROCESS B
      WHERE AUDSID = USERENV('SESSIONID')
        AND A.PADDR = B.ADDR;

Line: 208

      SELECT
        NVL(NAME
           ,'')
      FROM
        V$DATABASE;