APPS.AR_ARBRRMBM_XMLP_PKG SQL Statements

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

Line: 9

      SELECT
        CP.USER_CONCURRENT_PROGRAM_NAME
      INTO L_REPORT_NAME
      FROM
        FND_CONCURRENT_PROGRAMS_VL CP,
        FND_APPLICATION_VL AP
      WHERE AP.APPLICATION_ID = CP.APPLICATION_ID
        AND CP.CONCURRENT_PROGRAM_NAME = 'ARBRRMBM'
        AND AP.APPLICATION_SHORT_NAME = 'AR';

Line: 161

      SELECT
        MEANING
      INTO L_SORT_BY
      FROM
        AR_LOOKUPS
      WHERE LOOKUP_TYPE = 'SORT_BY_ARXAPRMB'
        AND LOOKUP_CODE = CP_SORT_BY;

Line: 181

      SELECT
        MEANING
      INTO L_STATUS
      FROM
        AR_LOOKUPS
      WHERE LOOKUP_TYPE = 'BATCH_APPLIED_STATUS'
        AND LOOKUP_CODE = P_STATUS;

Line: 201

      SELECT
        MEANING
      INTO L_REM_MET
      FROM
        AR_LOOKUPS
      WHERE LOOKUP_TYPE = 'REMITTANCE_METHOD'
        AND ENABLED_FLAG = 'Y'
        AND LOOKUP_CODE = P_REMITTANCE_METHOD;

Line: 222

      SELECT
        BANK_ACCOUNT_NAME
      INTO L_REM_ACC
      FROM
        CE_BANK_ACCOUNTS
      WHERE BANK_ACCOUNT_ID = P_REMIT_BANK_ACCOUNT;

Line: 241

      SELECT
        MEANING
      INTO L_INC_FORM
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND ENABLED_FLAG = 'Y'
        AND LOOKUP_CODE = P_INCLUDE_FORMATTED;

Line: 262

      SELECT
        MEANING
      INTO L_SUM_OR_DET
      FROM
        AR_LOOKUPS
      WHERE LOOKUP_TYPE = 'ARXAPRMB_SD'
        AND ENABLED_FLAG = 'Y'
        AND LOOKUP_CODE = P_SUMMARY_OR_DETAILED;