eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_BANKACCT_BA_REPORT_UTIL dependencies on CE_BANK_ACCOUNTS

Line 105: v_currency_code ce_bank_accounts.currency_code%type;

101: return number
102: is
103: v_variance number :=0;
104: v_record_num varchar2(30);
105: v_currency_code ce_bank_accounts.currency_code%type;
106: begin
107:
108: if p_actual_balance_type = 'L' then
109: select count(1)

Line 121: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba

117: and pb.PROJECTED_BALANCE is not null;
118: if v_record_num = 1 then
119: select bb.LEDGER_BALANCE - pb.PROJECTED_BALANCE, ba.CURRENCY_CODE
120: into v_variance, v_currency_code
121: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
122: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
123: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
124: and bb.BALANCE_DATE = p_balance_date
125: and pb.BALANCE_DATE = p_balance_date

Line 149: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba

145:
146: if v_record_num = 1 then
147: select bb.VALUE_DATED_BALANCE - pb.PROJECTED_BALANCE, ba.CURRENCY_CODE
148: into v_variance, v_currency_code
149: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
150: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
151: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
152: and bb.BALANCE_DATE = p_balance_date
153: and pb.BALANCE_DATE = p_balance_date

Line 175: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba

171: and pb.PROJECTED_BALANCE is not null;
172: if v_record_num = 1 then
173: select bb.AVAILABLE_BALANCE - pb.PROJECTED_BALANCE, ba.currency_code
174: into v_variance, v_currency_code
175: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
176: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
177: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
178: and bb.BALANCE_DATE = p_balance_date
179: and pb.BALANCE_DATE = p_balance_date

Line 201: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba

197: and pb.PROJECTED_BALANCE is not null;
198: if v_record_num = 1 then
199: select bb.ONE_DAY_FLOAT - pb.PROJECTED_BALANCE, ba.currency_code
200: into v_variance, v_currency_code
201: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
202: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
203: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
204: and bb.BALANCE_DATE = p_balance_date
205: and pb.BALANCE_DATE = p_balance_date

Line 227: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba

223: and pb.PROJECTED_BALANCE is not null;
224: if v_record_num = 1 then
225: select bb.TWO_DAY_FLOAT - pb.PROJECTED_BALANCE, ba.currency_code
226: into v_variance, v_currency_code
227: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
228: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
229: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
230: and bb.BALANCE_DATE = p_balance_date
231: and pb.BALANCE_DATE = p_balance_date

Line 253: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba

249: and pb.PROJECTED_BALANCE is not null;
250: if v_record_num = 1 then
251: select bb.AVERAGE_CLOSE_LEDGER_MTD - pb.PROJECTED_BALANCE, ba.currency_code
252: into v_variance, v_currency_code
253: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
254: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
255: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
256: and bb.BALANCE_DATE = p_balance_date
257: and pb.BALANCE_DATE = p_balance_date

Line 279: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba

275: and pb.PROJECTED_BALANCE is not null;
276: if v_record_num = 1 then
277: select bb.AVERAGE_CLOSE_LEDGER_YTD - pb.PROJECTED_BALANCE, ba.currency_code
278: into v_variance, v_currency_code
279: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
280: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
281: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
282: and bb.BALANCE_DATE = p_balance_date
283: and pb.BALANCE_DATE = p_balance_date

Line 305: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba

301: and pb.PROJECTED_BALANCE is not null;
302: if v_record_num = 1 then
303: select bb.AVERAGE_CLOSE_AVAILABLE_MTD - pb.PROJECTED_BALANCE, ba.currency_code
304: into v_variance, v_currency_code
305: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
306: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
307: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
308: and bb.BALANCE_DATE = p_balance_date
309: and pb.BALANCE_DATE = p_balance_date

Line 331: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba

327: and pb.PROJECTED_BALANCE is not null;
328: if v_record_num = 1 then
329: select bb.AVERAGE_CLOSE_AVAILABLE_YTD - pb.PROJECTED_BALANCE, ba.currency_code
330: into v_variance, v_currency_code
331: from ce_bank_acct_balances bb, ce_projected_balances pb, ce_bank_accounts ba
332: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
333: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
334: and bb.BALANCE_DATE = p_balance_date
335: and pb.BALANCE_DATE = p_balance_date