APPS.AR_ARBARL_XMLP_PKG SQL Statements

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

Line: 63

        SELECT COUNT(*)
        INTO LINES
        FROM RA_CUST_TRX_LINE_GL_DIST
        WHERE REQUEST_ID = CONC_REQUEST_ID
          AND ACCOUNT_CLASS NOT IN ( 'UNEARN' , 'UNBILL' );

Line: 116

      SELECT
        'x'
      FROM
        DUAL
      WHERE exists (
        SELECT
          'x'
        FROM
          RA_CUST_TRX_LINE_GL_DIST
        WHERE REQUEST_ID = ID );