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_ACCT_BALANCES

Line 111: from ce_bank_acct_balances bb, ce_projected_balances pb

107:
108: if p_actual_balance_type = 'L' then
109: select count(1)
110: into v_record_num
111: from ce_bank_acct_balances bb, ce_projected_balances pb
112: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
113: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
114: and bb.BALANCE_DATE = p_balance_date
115: and pb.BALANCE_DATE = p_balance_date

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 138: from ce_bank_acct_balances bb, ce_projected_balances pb

134:
135: if p_actual_balance_type = 'I' then
136: select count(1)
137: into v_record_num
138: from ce_bank_acct_balances bb, ce_projected_balances pb
139: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
140: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
141: and bb.BALANCE_DATE = p_balance_date
142: 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 165: from ce_bank_acct_balances bb, ce_projected_balances pb

161:
162: if p_actual_balance_type = 'C' then
163: select count(1)
164: into v_record_num
165: from ce_bank_acct_balances bb, ce_projected_balances pb
166: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
167: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
168: and bb.BALANCE_DATE = p_balance_date
169: 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 191: from ce_bank_acct_balances bb, ce_projected_balances pb

187:
188: if p_actual_balance_type = 'O' then
189: select count(1)
190: into v_record_num
191: from ce_bank_acct_balances bb, ce_projected_balances pb
192: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
193: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
194: and bb.BALANCE_DATE = p_balance_date
195: 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 217: from ce_bank_acct_balances bb, ce_projected_balances pb

213:
214: if p_actual_balance_type = 'T' then
215: select count(1)
216: into v_record_num
217: from ce_bank_acct_balances bb, ce_projected_balances pb
218: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
219: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
220: and bb.BALANCE_DATE = p_balance_date
221: 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 243: from ce_bank_acct_balances bb, ce_projected_balances pb

239:
240: if p_actual_balance_type = 'CLM' then
241: select count(1)
242: into v_record_num
243: from ce_bank_acct_balances bb, ce_projected_balances pb
244: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
245: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
246: and bb.BALANCE_DATE = p_balance_date
247: 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 269: from ce_bank_acct_balances bb, ce_projected_balances pb

265:
266: if p_actual_balance_type = 'CLY' then
267: select count(1)
268: into v_record_num
269: from ce_bank_acct_balances bb, ce_projected_balances pb
270: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
271: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
272: and bb.BALANCE_DATE = p_balance_date
273: 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 295: from ce_bank_acct_balances bb, ce_projected_balances pb

291:
292: if p_actual_balance_type = 'CAM' then
293: select count(1)
294: into v_record_num
295: from ce_bank_acct_balances bb, ce_projected_balances pb
296: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
297: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
298: and bb.BALANCE_DATE = p_balance_date
299: 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 321: from ce_bank_acct_balances bb, ce_projected_balances pb

317:
318: if p_actual_balance_type = 'CAY' then
319: select count(1)
320: into v_record_num
321: from ce_bank_acct_balances bb, ce_projected_balances pb
322: where bb.BANK_ACCOUNT_ID = p_bank_acct_id
323: and pb.BANK_ACCOUNT_ID = p_bank_acct_id
324: and bb.BALANCE_DATE = p_balance_date
325: 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