APPS.JA_JAINSTCR_XMLP_PKG SQL Statements

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

Line: 33

      SELECT
        AMOUNT
      FROM
        RA_CUST_TRX_LINE_GL_DIST_ALL
      WHERE CUSTOMER_TRX_ID = INVOICE_ID1
        AND ACCOUNT_CLASS = CP_ACCT_CLASS - 'REC'
        AND LATEST_REC_FLAG = 'Y';

Line: 54

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

Line: 62

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

Line: 72

      SELECT
        NAME
      FROM
        V$DATABASE;

Line: 124

      SELECT
        ORDERED_DATE
      FROM
        OE_ORDER_HEADERS_ALL
      WHERE HEADER_ID = CF_ORDER_DATEFORMULA.HEADER_ID;

Line: 147

      SELECT
        FORM_NUMBER
      FROM
        JAI_CMN_ST_FORMS
      WHERE FORM_ID = CF_FORM_NUMBERFORMULA.FORM_ID;

Line: 166

      SELECT
        FORM_DATE
      FROM
        JAI_CMN_ST_FORMS
      WHERE FORM_ID = CF_FORM_DATEFORMULA.FORM_ID;