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_BANK_ACCT_BALANCE_REPORT dependencies on CE_BANK_ACCT_BALANCES

Line 21: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

17: return number
18: is
19: cursor cursor_bank_currency_code is
20: select distinct ba.CURRENCY_CODE
21: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
22: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
23: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
24: and bb.BALANCE_DATE = l_date
25: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 83: from ce_bank_acct_balances bb

79: if p_balance_type = 'LegerBalance' then
80:
81: select min(abs(BALANCE_DATE - p_date))
82: into v_date_offset
83: from ce_bank_acct_balances bb
84: where bb.BANK_ACCOUNT_ID = p_bank_account_id
85: and bb.LEDGER_BALANCE is not null
86: and balance_date < p_date; /*Bug 16164248*/
87:

Line 91: from ce_bank_acct_balances bb

87:
88: if v_date_offset is not null then
89: select min(balance_date)
90: into v_date
91: from ce_bank_acct_balances bb
92: where bb.BANK_ACCOUNT_ID = p_bank_account_id
93: and abs(BALANCE_DATE - p_date) = v_date_offset
94: and bb.LEDGER_BALANCE is not null
95: and balance_date < p_date; /*Bug 16164248*/

Line 99: from ce_bank_acct_balances

95: and balance_date < p_date; /*Bug 16164248*/
96:
97: select LEDGER_BALANCE
98: into v_balance
99: from ce_bank_acct_balances
100: where BANK_ACCOUNT_ID = p_bank_account_id
101: and BALANCE_DATE = v_date;
102: end if;
103:

Line 111: from ce_bank_acct_balances bb

107: if p_balance_type = 'AvailableBalance' then
108:
109: select min(abs(BALANCE_DATE - p_date))
110: into v_date_offset
111: from ce_bank_acct_balances bb
112: where bb.BANK_ACCOUNT_ID = p_bank_account_id
113: and bb.AVAILABLE_BALANCE is not null
114: and balance_date < p_date; /*Bug 16164248*/
115:

Line 119: from ce_bank_acct_balances bb

115:
116: if v_date_offset is not null then
117: select min(balance_date)
118: into v_date
119: from ce_bank_acct_balances bb
120: where bb.BANK_ACCOUNT_ID = p_bank_account_id
121: and abs(BALANCE_DATE - p_date) = v_date_offset
122: and bb.AVAILABLE_BALANCE is not null
123: and balance_date < p_date; /*Bug 16164248*/

Line 127: from ce_bank_acct_balances

123: and balance_date < p_date; /*Bug 16164248*/
124:
125: select AVAILABLE_BALANCE
126: into v_balance
127: from ce_bank_acct_balances
128: where BANK_ACCOUNT_ID = p_bank_account_id
129: and BALANCE_DATE = v_date;
130: end if;
131: end if;

Line 138: from ce_bank_acct_balances bb

134: if p_balance_type = 'IntCalBalance' then
135:
136: select min(abs(BALANCE_DATE - p_date))
137: into v_date_offset
138: from ce_bank_acct_balances bb
139: where bb.BANK_ACCOUNT_ID = p_bank_account_id
140: and bb.VALUE_DATED_BALANCE is not null
141: and balance_date < p_date; /*Bug 16164248*/
142:

Line 146: from ce_bank_acct_balances bb

142:
143: if v_date_offset is not null then
144: select min(balance_date)
145: into v_date
146: from ce_bank_acct_balances bb
147: where bb.BANK_ACCOUNT_ID = p_bank_account_id
148: and abs(BALANCE_DATE - p_date) = v_date_offset
149: and bb.VALUE_DATED_BALANCE is not null
150: and balance_date < p_date; /*Bug 16164248*/

Line 154: from ce_bank_acct_balances

150: and balance_date < p_date; /*Bug 16164248*/
151:
152: select VALUE_DATED_BALANCE
153: into v_balance
154: from ce_bank_acct_balances
155: where BANK_ACCOUNT_ID = p_bank_account_id
156: and BALANCE_DATE = v_date;
157:
158: end if;

Line 166: from ce_bank_acct_balances bb

162: if p_balance_type = 'OneDayFloat' then
163:
164: select min(abs(BALANCE_DATE - p_date))
165: into v_date_offset
166: from ce_bank_acct_balances bb
167: where bb.BANK_ACCOUNT_ID = p_bank_account_id
168: and bb.ONE_DAY_FLOAT is not null
169: and balance_date < p_date; /*Bug 16164248*/
170:

Line 174: from ce_bank_acct_balances bb

170:
171: if v_date_offset is not null then
172: select min(balance_date)
173: into v_date
174: from ce_bank_acct_balances bb
175: where bb.BANK_ACCOUNT_ID = p_bank_account_id
176: and abs(BALANCE_DATE - p_date) = v_date_offset
177: and bb.ONE_DAY_FLOAT is not null
178: and balance_date < p_date; /*Bug 16164248*/

Line 182: from ce_bank_acct_balances

178: and balance_date < p_date; /*Bug 16164248*/
179:
180: select ONE_DAY_FLOAT
181: into v_balance
182: from ce_bank_acct_balances
183: where BANK_ACCOUNT_ID = p_bank_account_id
184: and BALANCE_DATE = v_date;
185: end if;
186: end if;

Line 193: from ce_bank_acct_balances bb

189: if p_balance_type = 'TwoDayFloat' then
190:
191: select min(abs(BALANCE_DATE - p_date))
192: into v_date_offset
193: from ce_bank_acct_balances bb
194: where bb.BANK_ACCOUNT_ID = p_bank_account_id
195: and bb.TWO_DAY_FLOAT is not null
196: and balance_date < p_date; /*Bug 16164248*/
197:

Line 201: from ce_bank_acct_balances bb

197:
198: if v_date_offset is not null then
199: select min(balance_date)
200: into v_date
201: from ce_bank_acct_balances bb
202: where bb.BANK_ACCOUNT_ID = p_bank_account_id
203: and abs(BALANCE_DATE - p_date) = v_date_offset
204: and bb.TWO_DAY_FLOAT is not null
205: and balance_date < p_date; /*Bug 16164248*/

Line 209: from ce_bank_acct_balances

205: and balance_date < p_date; /*Bug 16164248*/
206:
207: select TWO_DAY_FLOAT
208: into v_balance
209: from ce_bank_acct_balances
210: where BANK_ACCOUNT_ID = p_bank_account_id
211: and BALANCE_DATE = v_date;
212: end if;
213: end if;

Line 220: from ce_bank_acct_balances bb

216: if p_balance_type = 'AvgLegerMTD' then
217:
218: select min(abs(BALANCE_DATE - p_date))
219: into v_date_offset
220: from ce_bank_acct_balances bb
221: where bb.BANK_ACCOUNT_ID = p_bank_account_id
222: and bb.AVERAGE_CLOSE_LEDGER_MTD is not null
223: and balance_date < p_date; /*Bug 16164248*/
224:

Line 228: from ce_bank_acct_balances bb

224:
225: if v_date_offset is not null then
226: select min(balance_date)
227: into v_date
228: from ce_bank_acct_balances bb
229: where bb.BANK_ACCOUNT_ID = p_bank_account_id
230: and abs(BALANCE_DATE - p_date) = v_date_offset
231: and bb.AVERAGE_CLOSE_LEDGER_MTD is not null
232: and balance_date < p_date; /*Bug 16164248*/

Line 236: from ce_bank_acct_balances

232: and balance_date < p_date; /*Bug 16164248*/
233:
234: select AVERAGE_CLOSE_LEDGER_MTD
235: into v_balance
236: from ce_bank_acct_balances
237: where BANK_ACCOUNT_ID = p_bank_account_id
238: and BALANCE_DATE = v_date;
239:
240: end if;

Line 248: from ce_bank_acct_balances bb

244: if p_balance_type = 'AvgLegerYTD' then
245:
246: select min(abs(BALANCE_DATE - p_date))
247: into v_date_offset
248: from ce_bank_acct_balances bb
249: where bb.BANK_ACCOUNT_ID = p_bank_account_id
250: and bb.AVERAGE_CLOSE_LEDGER_YTD is not null
251: and balance_date < p_date; /*Bug 16164248*/
252:

Line 256: from ce_bank_acct_balances bb

252:
253: if v_date_offset is not null then
254: select min(balance_date)
255: into v_date
256: from ce_bank_acct_balances bb
257: where bb.BANK_ACCOUNT_ID = p_bank_account_id
258: and abs(BALANCE_DATE - p_date) = v_date_offset
259: and bb.AVERAGE_CLOSE_LEDGER_YTD is not null
260: and balance_date < p_date; /*Bug 16164248*/

Line 264: from ce_bank_acct_balances

260: and balance_date < p_date; /*Bug 16164248*/
261:
262: select AVERAGE_CLOSE_LEDGER_YTD
263: into v_balance
264: from ce_bank_acct_balances
265: where BANK_ACCOUNT_ID = p_bank_account_id
266: and BALANCE_DATE = v_date;
267: end if;
268: end if;

Line 275: from ce_bank_acct_balances bb

271: if p_balance_type = 'AvgAvailableMTD' then
272:
273: select min(abs(BALANCE_DATE - p_date))
274: into v_date_offset
275: from ce_bank_acct_balances bb
276: where bb.BANK_ACCOUNT_ID = p_bank_account_id
277: and bb.AVERAGE_CLOSE_AVAILABLE_MTD is not null
278: and balance_date < p_date; /*Bug 16164248*/
279:

Line 283: from ce_bank_acct_balances bb

279:
280: if v_date_offset is not null then
281: select min(balance_date)
282: into v_date
283: from ce_bank_acct_balances bb
284: where bb.BANK_ACCOUNT_ID = p_bank_account_id
285: and abs(BALANCE_DATE - p_date) = v_date_offset
286: and bb.AVERAGE_CLOSE_AVAILABLE_MTD is not null
287: and balance_date < p_date; /*Bug 16164248*/

Line 291: from ce_bank_acct_balances

287: and balance_date < p_date; /*Bug 16164248*/
288:
289: select AVERAGE_CLOSE_AVAILABLE_MTD
290: into v_balance
291: from ce_bank_acct_balances
292: where BANK_ACCOUNT_ID = p_bank_account_id
293: and BALANCE_DATE = v_date;
294: end if;
295: end if;

Line 302: from ce_bank_acct_balances bb

298: if p_balance_type = 'AvgAvailableYTD' then
299:
300: select min(abs(BALANCE_DATE - p_date))
301: into v_date_offset
302: from ce_bank_acct_balances bb
303: where bb.BANK_ACCOUNT_ID = p_bank_account_id
304: and bb.AVERAGE_CLOSE_AVAILABLE_YTD is not null
305: and balance_date < p_date; /*Bug 16164248*/
306:

Line 310: from ce_bank_acct_balances bb

306:
307: if v_date_offset is not null then
308: select min(balance_date)
309: into v_date
310: from ce_bank_acct_balances bb
311: where bb.BANK_ACCOUNT_ID = p_bank_account_id
312: and abs(BALANCE_DATE - p_date) = v_date_offset
313: and bb.AVERAGE_CLOSE_AVAILABLE_YTD is not null
314: and balance_date < p_date; /*Bug 16164248*/

Line 318: from ce_bank_acct_balances

314: and balance_date < p_date; /*Bug 16164248*/
315:
316: select AVERAGE_CLOSE_AVAILABLE_YTD
317: into v_balance
318: from ce_bank_acct_balances
319: where BANK_ACCOUNT_ID = p_bank_account_id
320: and BALANCE_DATE = v_date;
321:
322: end if;

Line 427: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

423: counterflag number; -- Bug 8620223
424:
425: cursor cursor_bank_currency_code is
426: select distinct ba.CURRENCY_CODE
427: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
428: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
429: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
430: -- Bug 8620223 and bb.BALANCE_DATE = l_date
431: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 439: --from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

435:
436: -- Bug 8620223
437: cursor cursor_bank_account_id (currency varchar2) is
438: select distinct ba.bank_account_id
439: --from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
440: from CE_BANK_ACCTS_GT_V ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
441: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
442: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
443: --and bb.BALANCE_DATE = l_date

Line 440: from CE_BANK_ACCTS_GT_V ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

436: -- Bug 8620223
437: cursor cursor_bank_account_id (currency varchar2) is
438: select distinct ba.bank_account_id
439: --from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
440: from CE_BANK_ACCTS_GT_V ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
441: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
442: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
443: --and bb.BALANCE_DATE = l_date
444: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 569: from ce_bank_acct_balances bb

565: -- Bug 8620223
566: begin
567: select bb.LEDGER_BALANCE, bb.AVAILABLE_BALANCE, bb.VALUE_DATED_BALANCE, bb.ONE_DAY_FLOAT, bb.TWO_DAY_FLOAT, bb.AVERAGE_CLOSE_LEDGER_MTD, bb.AVERAGE_CLOSE_LEDGER_YTD, bb.AVERAGE_CLOSE_AVAILABLE_MTD, bb.AVERAGE_CLOSE_AVAILABLE_YTD
568: into v_LegerBalanceAC, v_AvailableBalanceAC, v_IntCalBalanceAC, v_OneDayFloatAC, v_TwoDayFloatAC, v_AvgLegerMTDAC, v_AvgLegerYTDAC, v_AvgAvailableMTDAC, v_AvgAvailableYTDAC
569: from ce_bank_acct_balances bb
570: where bb.BALANCE_DATE = l_date
571: and bb.BANK_ACCOUNT_ID = v_bank_account_id;
572: Exception
573: when no_data_found THEN

Line 915: from ce_bank_accounts ba, ce_bank_branches_v bh -- , ce_bank_acct_balances bb

911: xmlelement("AvgAvailableYTDAC", xmlattributes(v_AvgAvailableYTD_Date as "BalanceDate", decode(v_AvgAvailableYTD_Date - l_date, 0, '', '*') as "Flag"), CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableYTDAC, ba.CURRENCY_CODE)),
912: xmlelement("AvgAvailableYTDRC", CE_BANKACCT_BA_REPORT_UTIL.get_balance(v_AvgAvailableYTDRC, p_reporting_currency))
913: )
914: into v_xml_seg1
915: from ce_bank_accounts ba, ce_bank_branches_v bh -- , ce_bank_acct_balances bb
916: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
917: --and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
918: -- and bb.BALANCE_DATE = l_date
919: and ba.BANK_ACCOUNT_ID = v_bank_account_id;

Line 1146: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb

1142: CE_BANKACCT_BA_REPORT_UTIL.get_balance(bb.AVERAGE_CLOSE_AVAILABLE_YTD, ba.CURRENCY_CODE) as "AvgCloseAvailableYTDAC",
1143: CE_BANKACCT_BA_REPORT_UTIL.get_reporting_balance(bb.AVERAGE_CLOSE_AVAILABLE_YTD, ba.CURRENCY_CODE, p_reporting_currency, p_exchange_rate_date,p_exchange_rate_type) as "AvgCloseAvailableYTDRC"
1144: ))ORDER BY bb.BALANCE_DATE)) -- Bug 6632931
1145: into l_xml
1146: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb
1147: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
1148: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
1149: and bb.BALANCE_DATE between nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE) and nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE)
1150: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 1339: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb

1335: bb.AVERAGE_CLOSE_LEDGER_YTD,
1336: bb.AVERAGE_CLOSE_AVAILABLE_MTD,
1337: bb.AVERAGE_CLOSE_AVAILABLE_YTD,
1338: pb.PROJECTED_BALANCE
1339: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb
1340: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
1341: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
1342: and bb.BALANCE_DATE between nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE) and nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE)
1343: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)

Line 1373: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb

1369: bb.AVERAGE_CLOSE_LEDGER_YTD,
1370: bb.AVERAGE_CLOSE_AVAILABLE_MTD,
1371: bb.AVERAGE_CLOSE_AVAILABLE_YTD,
1372: pb.PROJECTED_BALANCE
1373: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb
1374: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
1375: and ba.BANK_ACCOUNT_ID = pb.BANK_ACCOUNT_ID
1376: and pb.BALANCE_DATE between nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE) and nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE)
1377: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)