APPS.CE_BANKACCT_BA_REPORT_UTIL SQL Statements

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

Line: 109

  select count(1)
  into v_record_num
  from ce_bank_acct_balances bb, ce_projected_balances pb
  where bb.BANK_ACCOUNT_ID = p_bank_acct_id
    and pb.BANK_ACCOUNT_ID = p_bank_acct_id
    and bb.BALANCE_DATE = p_balance_date
    and pb.BALANCE_DATE = p_balance_date
    and bb.LEDGER_BALANCE is not null
    and pb.PROJECTED_BALANCE is not null;

Line: 119

    select bb.LEDGER_BALANCE - pb.PROJECTED_BALANCE, ba.CURRENCY_CODE
    into v_variance, v_currency_code
    from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
    where bb.BANK_ACCOUNT_ID = p_bank_acct_id
      and pb.BANK_ACCOUNT_ID = p_bank_acct_id
      and bb.BALANCE_DATE = p_balance_date
      and pb.BALANCE_DATE = p_balance_date
      and bb.LEDGER_BALANCE is not null
      and pb.PROJECTED_BALANCE is not null
      and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;

Line: 136

  select count(1)
  into v_record_num
  from ce_bank_acct_balances bb, ce_projected_balances pb
  where bb.BANK_ACCOUNT_ID = p_bank_acct_id
    and pb.BANK_ACCOUNT_ID = p_bank_acct_id
    and bb.BALANCE_DATE = p_balance_date
    and pb.BALANCE_DATE = p_balance_date
    and bb.VALUE_DATED_BALANCE is not null
    and pb.PROJECTED_BALANCE is not null;

Line: 147

    select bb.VALUE_DATED_BALANCE - pb.PROJECTED_BALANCE, ba.CURRENCY_CODE
    into v_variance, v_currency_code
    from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
    where bb.BANK_ACCOUNT_ID = p_bank_acct_id
      and pb.BANK_ACCOUNT_ID = p_bank_acct_id
      and bb.BALANCE_DATE = p_balance_date
      and pb.BALANCE_DATE = p_balance_date
      and bb.VALUE_DATED_BALANCE is not null
      and pb.PROJECTED_BALANCE is not null
      and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;

Line: 163

  select count(1)
  into v_record_num
  from ce_bank_acct_balances bb, ce_projected_balances pb
  where bb.BANK_ACCOUNT_ID = p_bank_acct_id
    and pb.BANK_ACCOUNT_ID = p_bank_acct_id
    and bb.BALANCE_DATE = p_balance_date
    and pb.BALANCE_DATE = p_balance_date
    and bb.AVAILABLE_BALANCE is not null
    and pb.PROJECTED_BALANCE is not null;

Line: 173

    select bb.AVAILABLE_BALANCE - pb.PROJECTED_BALANCE, ba.currency_code
    into v_variance, v_currency_code
    from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
    where bb.BANK_ACCOUNT_ID = p_bank_acct_id
      and pb.BANK_ACCOUNT_ID = p_bank_acct_id
      and bb.BALANCE_DATE = p_balance_date
      and pb.BALANCE_DATE = p_balance_date
      and bb.AVAILABLE_BALANCE is not null
      and pb.PROJECTED_BALANCE is not null
      and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;

Line: 189

  select count(1)
  into v_record_num
  from ce_bank_acct_balances bb, ce_projected_balances pb
  where bb.BANK_ACCOUNT_ID = p_bank_acct_id
    and pb.BANK_ACCOUNT_ID = p_bank_acct_id
    and bb.BALANCE_DATE = p_balance_date
    and pb.BALANCE_DATE = p_balance_date
    and bb.ONE_DAY_FLOAT is not null
    and pb.PROJECTED_BALANCE is not null;

Line: 199

    select bb.ONE_DAY_FLOAT - pb.PROJECTED_BALANCE, ba.currency_code
    into v_variance, v_currency_code
    from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
    where bb.BANK_ACCOUNT_ID = p_bank_acct_id
      and pb.BANK_ACCOUNT_ID = p_bank_acct_id
      and bb.BALANCE_DATE = p_balance_date
      and pb.BALANCE_DATE = p_balance_date
      and bb.ONE_DAY_FLOAT is not null
      and pb.PROJECTED_BALANCE is not null
      and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;

Line: 215

  select count(1)
  into v_record_num
  from ce_bank_acct_balances bb, ce_projected_balances pb
  where bb.BANK_ACCOUNT_ID = p_bank_acct_id
    and pb.BANK_ACCOUNT_ID = p_bank_acct_id
    and bb.BALANCE_DATE = p_balance_date
    and pb.BALANCE_DATE = p_balance_date
    and bb.TWO_DAY_FLOAT is not null
    and pb.PROJECTED_BALANCE is not null;

Line: 225

    select bb.TWO_DAY_FLOAT - pb.PROJECTED_BALANCE, ba.currency_code
    into v_variance, v_currency_code
    from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
    where bb.BANK_ACCOUNT_ID = p_bank_acct_id
      and pb.BANK_ACCOUNT_ID = p_bank_acct_id
      and bb.BALANCE_DATE = p_balance_date
      and pb.BALANCE_DATE = p_balance_date
      and bb.TWO_DAY_FLOAT is not null
      and pb.PROJECTED_BALANCE is not null
      and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;

Line: 241

  select count(1)
  into v_record_num
  from ce_bank_acct_balances bb, ce_projected_balances pb
  where bb.BANK_ACCOUNT_ID = p_bank_acct_id
    and pb.BANK_ACCOUNT_ID = p_bank_acct_id
    and bb.BALANCE_DATE = p_balance_date
    and pb.BALANCE_DATE = p_balance_date
    and bb.AVERAGE_CLOSE_LEDGER_MTD is not null
    and pb.PROJECTED_BALANCE is not null;

Line: 251

    select bb.AVERAGE_CLOSE_LEDGER_MTD - pb.PROJECTED_BALANCE, ba.currency_code
    into v_variance, v_currency_code
    from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
    where bb.BANK_ACCOUNT_ID = p_bank_acct_id
      and pb.BANK_ACCOUNT_ID = p_bank_acct_id
      and bb.BALANCE_DATE = p_balance_date
      and pb.BALANCE_DATE = p_balance_date
      and bb.AVERAGE_CLOSE_LEDGER_MTD is not null
      and pb.PROJECTED_BALANCE is not null
      and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;

Line: 267

  select count(1)
  into v_record_num
  from ce_bank_acct_balances bb, ce_projected_balances pb
  where bb.BANK_ACCOUNT_ID = p_bank_acct_id
    and pb.BANK_ACCOUNT_ID = p_bank_acct_id
    and bb.BALANCE_DATE = p_balance_date
    and pb.BALANCE_DATE = p_balance_date
    and bb.AVERAGE_CLOSE_LEDGER_YTD is not null
    and pb.PROJECTED_BALANCE is not null;

Line: 277

    select bb.AVERAGE_CLOSE_LEDGER_YTD - pb.PROJECTED_BALANCE, ba.currency_code
    into v_variance, v_currency_code
    from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
    where bb.BANK_ACCOUNT_ID = p_bank_acct_id
      and pb.BANK_ACCOUNT_ID = p_bank_acct_id
      and bb.BALANCE_DATE = p_balance_date
      and pb.BALANCE_DATE = p_balance_date
      and bb.AVERAGE_CLOSE_LEDGER_YTD is not null
      and pb.PROJECTED_BALANCE is not null
      and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;

Line: 293

  select count(1)
  into v_record_num
  from ce_bank_acct_balances bb, ce_projected_balances pb
  where bb.BANK_ACCOUNT_ID = p_bank_acct_id
    and pb.BANK_ACCOUNT_ID = p_bank_acct_id
    and bb.BALANCE_DATE = p_balance_date
    and pb.BALANCE_DATE = p_balance_date
    and bb.AVERAGE_CLOSE_AVAILABLE_MTD is not null
    and pb.PROJECTED_BALANCE is not null;

Line: 303

    select bb.AVERAGE_CLOSE_AVAILABLE_MTD - pb.PROJECTED_BALANCE, ba.currency_code
    into v_variance, v_currency_code
    from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
    where bb.BANK_ACCOUNT_ID = p_bank_acct_id
      and pb.BANK_ACCOUNT_ID = p_bank_acct_id
      and bb.BALANCE_DATE = p_balance_date
      and pb.BALANCE_DATE = p_balance_date
      and bb.AVERAGE_CLOSE_AVAILABLE_MTD is not null
      and pb.PROJECTED_BALANCE is not null
      and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;

Line: 319

  select count(1)
  into v_record_num
  from ce_bank_acct_balances bb, ce_projected_balances pb
  where bb.BANK_ACCOUNT_ID = p_bank_acct_id
    and pb.BANK_ACCOUNT_ID = p_bank_acct_id
    and bb.BALANCE_DATE = p_balance_date
    and pb.BALANCE_DATE = p_balance_date
    and bb.AVERAGE_CLOSE_AVAILABLE_YTD is not null
    and pb.PROJECTED_BALANCE is not null;

Line: 329

    select bb.AVERAGE_CLOSE_AVAILABLE_YTD - pb.PROJECTED_BALANCE, ba.currency_code
    into v_variance, v_currency_code
    from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
    where bb.BANK_ACCOUNT_ID = p_bank_acct_id
      and pb.BANK_ACCOUNT_ID = p_bank_acct_id
      and bb.BALANCE_DATE = p_balance_date
      and pb.BALANCE_DATE = p_balance_date
      and bb.AVERAGE_CLOSE_AVAILABLE_YTD is not null
      and pb.PROJECTED_BALANCE is not null
      and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID;