APPS.AR_RAXGLA_XMLP_PKG SQL Statements

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

Line: 26

        P_SELECT_1 := ' sum(decode(sign(gl_dist.amount),
                                        				 1, round(gl_dist.amount, 2), NULL)) curr_credit_amount,
                              			 sum(decode(sign(gl_dist.amount),
                                         				-1, -round(gl_dist.amount, 2), NULL)) curr_debit_amount ';

Line: 73

      SELECT
        CP.USER_CONCURRENT_PROGRAM_NAME
      INTO L_REPORT_NAME
      FROM
        FND_CONCURRENT_PROGRAMS_VL CP,
        FND_CONCURRENT_REQUESTS CR
      WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
        AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
        AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;

Line: 132

      SELECT
        MEANING
      INTO L_MEANING
      FROM
        AR_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES/NO'
        AND LOOKUP_CODE = P_REPORT_BY_LINE;

Line: 264

      SELECT
        MEANING
      INTO STATUS_MEANING
      FROM
        AR_LOOKUPS
      WHERE LOOKUP_TYPE = 'POSTING_STATUS'
        AND LOOKUP_CODE = NVL(P_POSTING_STATUS
         ,'ALL');

Line: 284

        SELECT
          MEANING
        INTO ACCT_MEANING
        FROM
          AR_LOOKUPS
        WHERE LOOKUP_TYPE = 'AUTOGL_TYPE'
          AND LOOKUP_CODE = P_GL_ACCOUNT_TYPE;

Line: 304

        SELECT
          MEANING
        INTO ORDER_MEANING
        FROM
          AR_LOOKUPS
        WHERE LOOKUP_TYPE = 'SORT_BY_RAXGLR'
          AND LOOKUP_CODE = P_SORT_BY;