APPS.AR_ARZACS_XMLP_PKG SQL Statements

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

Line: 49

      SELECT
        NAME
      INTO OUT_TRANS_TYPE_NAME
      FROM
        RA_CUST_TRX_TYPES
      WHERE CUST_TRX_TYPE_ID = P_BR_TRANSACTION_TYPE;

Line: 68

      P_AUTO_CLEAR_RECEIPTS := ' (crh.cash_receipt_id in ' || ' (select rap.cash_receipt_id from ' ||
      ' ar_transaction_history trh,ar_receivable_applications rap ' || ' where trh.request_id = :p_conc_request_id and ' ||
      ' trh.current_record_flag = ''Y''  and ' || ' rap.applied_customer_trx_id = trh.customer_trx_id) and ' || ' crh.current_record_flag =  ''Y'')
      and ';

Line: 127

    SELECT
      SOB.NAME,
      SOB.CURRENCY_CODE
    INTO COMPANY_NAME,FUNC_CURRENCY_CODE
    FROM
      GL_SETS_OF_BOOKS SOB,
      AR_SYSTEM_PARAMETERS AR
    WHERE SOB.SET_OF_BOOKS_ID = AR.SET_OF_BOOKS_ID;

Line: 147

      SELECT
        NAME
      INTO C_PAYMENT_METHOD_NAME
      FROM
        AR_RECEIPT_METHODS
      WHERE RECEIPT_METHOD_ID = P_PAYMENT_METHOD_ID;

Line: 166

      SELECT
        BANK_ACCOUNT_NAME
      INTO C_REMITTANCE_BANK_ACC_NAME
      FROM
        CE_BANK_ACCOUNTS CBA,
        CE_BANK_ACCT_USES BA
      WHERE BANK_ACCT_USE_ID = P_REMITTANCE_BANK_ACCOUNT_ID
        AND CBA.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID;

Line: 187

      SELECT
        NAME,
        BATCH_ID
      INTO C_REMITTANCE_BATCH_NAME,P_BATCH_ID
      FROM
        AR_BATCHES
      WHERE NAME = P_BATCH_NAME;

Line: 206

    SELECT
      MAX(CRH.CASH_RECEIPT_HISTORY_ID)
    INTO MAX_CRH_ID
    FROM
      AR_CASH_RECEIPT_HISTORY CRH;

Line: 223

    SELECT
      MEANING
    INTO NLS_YES
    FROM
      AR_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES/NO'
      AND LOOKUP_CODE = 'Y';

Line: 243

    SELECT
      MEANING
    INTO NLS_NO
    FROM
      AR_LOOKUPS LN
    WHERE LOOKUP_TYPE = 'YES/NO'
      AND LN.LOOKUP_CODE = 'N';

Line: 374

    SELECT
      count(*)
    INTO OPEN_PERIODS
    FROM
      GL_PERIOD_STATUSES GPS,
      AR_SYSTEM_PARAMETERS ASP
    WHERE GPS.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID
      AND GPS.APPLICATION_ID = 222
      AND GPS.ADJUSTMENT_PERIOD_FLAG = 'N'
      AND P_GL_DATE BETWEEN GPS.START_DATE
      AND GPS.END_DATE
      AND GPS.CLOSING_STATUS in ( 'O' , 'F' );