APPS.CE_BAL_UTIL dependencies on CE_BANK_ACCT_BALANCES

Line 46: from ce_bank_acct_balances

42: l_balance NUMBER;
43: in_rec p_accts%ROWTYPE;
44: CURSOR c_bal_1 IS
45: select value_dated_balance
46: from ce_bank_acct_balances
47: where balance_date = p_date
48: and bank_account_id = in_rec.account_id;
49: BEGIN
50: LOOP

Line 58: from CE_BANK_ACCT_BALANCES Bal

54: FETCH c_bal_1 INTO l_balance;
55: IF c_bal_1%NOTFOUND THEN
56: select Bal.value_dated_balance
57: into l_balance
58: from CE_BANK_ACCT_BALANCES Bal
59: where Bal.bank_account_id = in_rec.account_id
60: and trunc(Bal.balance_date) =
61: (select trunc(max(Bal2.balance_date))
62: from CE_BANK_ACCT_BALANCES Bal2

Line 62: from CE_BANK_ACCT_BALANCES Bal2

58: from CE_BANK_ACCT_BALANCES Bal
59: where Bal.bank_account_id = in_rec.account_id
60: and trunc(Bal.balance_date) =
61: (select trunc(max(Bal2.balance_date))
62: from CE_BANK_ACCT_BALANCES Bal2
63: where Bal2.value_dated_balance is NOT NULL
64: and Bal2.bank_account_id = in_rec.account_id
65: and trunc(Bal2.balance_date) <= trunc(p_date));
66: END IF;

Line 79: FROM CE_BANK_ACCT_BALANCES Bal

75: FUNCTION get_balance(p_acct_id IN NUMBER,
76: p_date IN DATE) RETURN NUMBER IS
77: CURSOR c_last_balance IS
78: SELECT Bal.interest_calculated_balance
79: FROM CE_BANK_ACCT_BALANCES Bal
80: WHERE Bal.bank_account_id = p_acct_id
81: AND Bal.balance_date =
82: (select max(Bal2.balance_date)
83: from CE_BANK_ACCT_BALANCES Bal2

Line 83: from CE_BANK_ACCT_BALANCES Bal2

79: FROM CE_BANK_ACCT_BALANCES Bal
80: WHERE Bal.bank_account_id = p_acct_id
81: AND Bal.balance_date =
82: (select max(Bal2.balance_date)
83: from CE_BANK_ACCT_BALANCES Bal2
84: where Bal2.interest_calculated_balance is NOT NULL
85: and Bal2.bank_account_id = p_acct_id
86: and trunc(Bal2.balance_date) <= trunc(p_date));
87: l_balance NUMBER := 0;

Line 109: from ce_bank_acct_balances

105: FROM ce_cashpool_sub_accts
106: WHERE cashpool_id = p_cashpool_id;
107: CURSOR c_bal(p_acct_id NUMBER) IS
108: select value_dated_balance
109: from ce_bank_acct_balances
110: where balance_date = p_balance_date
111: and bank_account_id = p_acct_id
112: and value_dated_balance is NOT NULL;
113: CURSOR c_last_bal(p_acct_id NUMBER) IS

Line 115: from CE_BANK_ACCT_BALANCES ce_bal

111: and bank_account_id = p_acct_id
112: and value_dated_balance is NOT NULL;
113: CURSOR c_last_bal(p_acct_id NUMBER) IS
114: select ce_bal.value_dated_balance
115: from CE_BANK_ACCT_BALANCES ce_bal
116: where ce_bal.bank_account_id = p_acct_id
117: and trunc(ce_bal.balance_date) =
118: (select trunc(max(ce_bal2.balance_date))
119: from CE_BANK_ACCT_BALANCES ce_bal2

Line 119: from CE_BANK_ACCT_BALANCES ce_bal2

115: from CE_BANK_ACCT_BALANCES ce_bal
116: where ce_bal.bank_account_id = p_acct_id
117: and trunc(ce_bal.balance_date) =
118: (select trunc(max(ce_bal2.balance_date))
119: from CE_BANK_ACCT_BALANCES ce_bal2
120: where ce_bal2.value_dated_balance is NOT NULL
121: and ce_bal2.bank_account_id = p_acct_id
122: and trunc(ce_bal2.balance_date) <= trunc(p_balance_date));
123: l_acct_id NUMBER;

Line 145: from CE_BANK_ACCT_BALANCES ce_bal

141: CLOSE c_last_bal;
142: /*
143: select ce_bal.value_dated_balance
144: into l_balance
145: from CE_BANK_ACCT_BALANCES ce_bal
146: where ce_bal.bank_account_id = l_acct_id
147: and trunc(ce_bal.balance_date) =
148: (select trunc(max(ce_bal2.balance_date))
149: from CE_BANK_ACCT_BALANCES ce_bal2

Line 149: from CE_BANK_ACCT_BALANCES ce_bal2

145: from CE_BANK_ACCT_BALANCES ce_bal
146: where ce_bal.bank_account_id = l_acct_id
147: and trunc(ce_bal.balance_date) =
148: (select trunc(max(ce_bal2.balance_date))
149: from CE_BANK_ACCT_BALANCES ce_bal2
150: where ce_bal2.value_dated_balance is NOT NULL
151: and ce_bal2.bank_account_id = l_acct_id
152: and trunc(ce_bal2.balance_date) <= trunc(p_balance_date));
153: IF SQL%ROWCOUNT = 0 THEN