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_AND_ACCOUNT_UTIL dependencies on CE_BANK_ACCOUNTS

Line 28: FROM ce_bank_accounts

24: l_sub VARCHAR2(15);
25: BEGIN
26: SELECT bank_account_num
27: INTO l_bank_acct_num
28: FROM ce_bank_accounts
29: WHERE bank_account_id = p_bank_acct_id;
30:
31: l_len := LENGTH(l_bank_acct_num);
32:

Line 74: l_IBAN ce_bank_accounts.iban_number%type; -- 9930714

70:
71: FUNCTION get_masked_IBAN(p_bank_acct_id IN NUMBER)
72: RETURN VARCHAR2
73: IS
74: l_IBAN ce_bank_accounts.iban_number%type; -- 9930714
75: l_profile_value VARCHAR2(30);
76: l_len NUMBER;
77: l_sub VARCHAR2(5);
78: BEGIN

Line 81: FROM ce_bank_accounts

77: l_sub VARCHAR2(5);
78: BEGIN
79: SELECT IBAN_NUMBER
80: INTO l_IBAN
81: FROM ce_bank_accounts
82: WHERE bank_account_id = p_bank_acct_id;
83:
84: l_len := LENGTH(l_IBAN);
85:

Line 127: TYPE BankAcctIdTable IS TABLE OF ce_bank_accounts.bank_account_id%TYPE;

123: +=======================================================================*/
124: FUNCTION get_org_bank_acct_list(p_org_id IN NUMBER)
125: RETURN VARCHAR2
126: IS
127: TYPE BankAcctIdTable IS TABLE OF ce_bank_accounts.bank_account_id%TYPE;
128: --l_bank_acct_list VARCHAR2(4000) DEFAULT '@';
129: l_bank_acct_list VARCHAR2(4000);
130: bank_acct_idtbl BankAcctIdTable;
131: BEGIN

Line 223: FROM ce_bank_accounts ce_ba,

219: SELECT BA.bank_account_id
220: BULK COLLECT
221: INTO x_bank_acct_ids
222: FROM ( SELECT ce_ba.bank_account_id
223: FROM ce_bank_accounts ce_ba,
224: ce_bank_acct_uses_all ce_bau
225: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
226: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
227: AND (ce_ba.currency_code = p_currency

Line 232: FROM ce_bank_accounts

228: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
229: AND ce_bau.legal_entity_id = p_org_id
230: UNION
231: SELECT bank_account_id
232: FROM ce_bank_accounts
233: WHERE NVL(end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
234: AND (currency_code = p_currency
235: or MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
236: AND account_owner_org_id = p_org_id) BA;

Line 241: FROM ce_bank_accounts ce_ba,

237: ELSIF p_org_type in ('OPERATING_UNIT', 'BUSINESS_GROUP') THEN
238: SELECT ce_ba.bank_account_id
239: BULK COLLECT
240: INTO x_bank_acct_ids
241: FROM ce_bank_accounts ce_ba,
242: ce_bank_acct_uses_all ce_bau
243: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
244: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
245: AND (ce_ba.currency_code = p_currency

Line 294: FROM ce_bank_accounts ce_ba,

290: IF p_org_type = 'LEGAL_ENTITY' THEN
291: SELECT Count(BA.bank_account_id)
292: INTO l_count
293: FROM ( SELECT ce_ba.bank_account_id
294: FROM ce_bank_accounts ce_ba,
295: ce_bank_acct_uses_all ce_bau
296: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
297: AND ce_ba.bank_account_id = p_internal_bank_account_id
298: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)

Line 304: FROM ce_bank_accounts

300: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
301: AND ce_bau.legal_entity_id = p_org_id
302: UNION
303: SELECT bank_account_id
304: FROM ce_bank_accounts
305: WHERE bank_account_id = p_internal_bank_account_id
306: AND NVL(end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
307: AND (currency_code = p_currency
308: or MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527

Line 315: FROM ce_bank_accounts ce_ba,

311:
312: ELSIF p_org_type in ('OPERATING_UNIT', 'BUSINESS_GROUP') THEN
313: SELECT Count(ce_ba.bank_account_id)
314: INTO l_count
315: FROM ce_bank_accounts ce_ba,
316: ce_bank_acct_uses_all ce_bau
317: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
318: AND ce_ba.bank_account_id = p_internal_bank_account_id
319: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)

Line 338: FROM ce_bank_accounts ce_ba,

334: SELECT BA.bank_account_id
335: BULK COLLECT
336: INTO l_bank_acct_ids
337: FROM ( SELECT ce_ba.bank_account_id
338: FROM ce_bank_accounts ce_ba,
339: ce_bank_acct_uses_all ce_bau
340: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
341: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
342: AND (ce_ba.currency_code = p_currency

Line 347: FROM ce_bank_accounts

343: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
344: AND ce_bau.legal_entity_id = p_org_id
345: UNION
346: SELECT bank_account_id
347: FROM ce_bank_accounts
348: WHERE NVL(end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
349: AND (currency_code = p_currency
350: or MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
351: AND account_owner_org_id = p_org_id) BA;

Line 357: FROM ce_bank_accounts ce_ba,

353: ELSIF p_org_type in ('OPERATING_UNIT', 'BUSINESS_GROUP') THEN
354: SELECT ce_ba.bank_account_id
355: BULK COLLECT
356: INTO l_bank_acct_ids
357: FROM ce_bank_accounts ce_ba,
358: ce_bank_acct_uses_all ce_bau
359: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
360: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
361: AND (ce_ba.currency_code = p_currency