APPS.CE_BAL_UTIL SQL Statements

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

Line: 45

         select value_dated_balance
         from   ce_bank_acct_balances
         where  balance_date = p_date
         and    bank_account_id = in_rec.account_id;

Line: 56

          select Bal.value_dated_balance
          into   l_balance
          from   CE_BANK_ACCT_BALANCES Bal
          where  Bal.bank_account_id = in_rec.account_id
          and    trunc(Bal.balance_date) =
                       (select trunc(max(Bal2.balance_date))
                        from   CE_BANK_ACCT_BALANCES Bal2
                        where  Bal2.value_dated_balance is NOT NULL
                        and    Bal2.bank_account_id = in_rec.account_id
                        and    trunc(Bal2.balance_date) <= trunc(p_date));

Line: 78

       SELECT Bal.interest_calculated_balance
       FROM   CE_BANK_ACCT_BALANCES  Bal
       WHERE  Bal.bank_account_id = p_acct_id
       AND    Bal.balance_date =
                       (select max(Bal2.balance_date)
                        from   CE_BANK_ACCT_BALANCES Bal2
                        where  Bal2.interest_calculated_balance is NOT NULL
                        and    Bal2.bank_account_id = p_acct_id
                        and    trunc(Bal2.balance_date) <= trunc(p_date));

Line: 104

       SELECT account_id
       FROM   ce_cashpool_sub_accts
       WHERE  cashpool_id = p_cashpool_id;

Line: 108

         select value_dated_balance
         from   ce_bank_acct_balances
         where  balance_date = p_balance_date
         and    bank_account_id = p_acct_id
         and    value_dated_balance is NOT NULL;

Line: 114

	select ce_bal.value_dated_balance
        from   CE_BANK_ACCT_BALANCES ce_bal
        where  ce_bal.bank_account_id = p_acct_id
        and    trunc(ce_bal.balance_date) =
                       (select trunc(max(ce_bal2.balance_date))
                        from   CE_BANK_ACCT_BALANCES  ce_bal2
                        where  ce_bal2.value_dated_balance is NOT NULL
                        and    ce_bal2.bank_account_id = p_acct_id
                        and    trunc(ce_bal2.balance_date) <= trunc(p_balance_date));

Line: 143

        select ce_bal.value_dated_balance
        into   l_balance
        from   CE_BANK_ACCT_BALANCES ce_bal
        where  ce_bal.bank_account_id = l_acct_id
        and    trunc(ce_bal.balance_date) =
                       (select trunc(max(ce_bal2.balance_date))
                        from   CE_BANK_ACCT_BALANCES  ce_bal2
                        where  ce_bal2.value_dated_balance is NOT NULL
                        and    ce_bal2.bank_account_id = l_acct_id
                        and    trunc(ce_bal2.balance_date) <= trunc(p_balance_date));