APPS.JA_JAINEXCL_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      ORGANIZATION_NAME
    INTO V_ORGANIZATION_NAME
    FROM
      ORG_ORGANIZATION_DEFINITIONS
    WHERE ORGANIZATION_ID = ORGANIZATION_ID_V;

Line: 18

    SELECT
      LOCATION_CODE
    INTO V_LOCATION_CODE
    FROM
      HR_LOCATIONS
    WHERE LOCATION_ID = LOCATION_ID_V;

Line: 29

      SELECT
        SET_OF_BOOKS_ID
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = INV_ORG_ID;

Line: 35

      SELECT
        NAME
      FROM
        GL_SETS_OF_BOOKS
      WHERE SET_OF_BOOKS_ID = SOB_ID;

Line: 56

      SELECT
        PARTY_NAME
      FROM
        HZ_PARTIES HP,
        HZ_CUST_ACCOUNTS HCA
      WHERE HP.PARTY_ID = HCA.PARTY_ID
        AND HCA.CUST_ACCOUNT_ID = C_ID;

Line: 74

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

Line: 84

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

Line: 94

      SELECT
        NAME
      FROM
        V$DATABASE;

Line: 176

    SELECT
      SUM(RTL.TAX_AMOUNT)
    INTO LN_CESS_AMT
    FROM
      JAI_OM_OE_RMA_TAXES RTL,
      JAI_CMN_TAXES_ALL JTC
    WHERE RTL.RMA_LINE_ID = RMA_LINE_ID_V
      AND JTC.TAX_ID = RTL.TAX_ID
      AND JTC.TAX_TYPE in ( 'CVD_EDUCATION_CESS' , 'EXCISE_EDUCATION_CESS' );