APPS.CE_BANK_AND_ACCOUNT_UTIL dependencies on CE_BANK_ACCOUNTS

Line 28: FROM ce_bank_accounts

24: l_sub VARCHAR2(5);
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 69: TYPE BankAcctIdTable IS TABLE OF ce_bank_accounts.bank_account_id%TYPE;

65: +=======================================================================*/
66: FUNCTION get_org_bank_acct_list(p_org_id IN NUMBER)
67: RETURN VARCHAR2
68: IS
69: TYPE BankAcctIdTable IS TABLE OF ce_bank_accounts.bank_account_id%TYPE;
70: --l_bank_acct_list VARCHAR2(4000) DEFAULT '@';
71: l_bank_acct_list VARCHAR2(4000);
72: bank_acct_idtbl BankAcctIdTable;
73: BEGIN

Line 165: FROM ce_bank_accounts ce_ba,

161: SELECT BA.bank_account_id
162: BULK COLLECT
163: INTO x_bank_acct_ids
164: FROM ( SELECT ce_ba.bank_account_id
165: FROM ce_bank_accounts ce_ba,
166: ce_bank_acct_uses_all ce_bau
167: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
168: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
169: AND (ce_ba.currency_code = p_currency

Line 174: FROM ce_bank_accounts

170: or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
171: AND ce_bau.legal_entity_id = p_org_id
172: UNION
173: SELECT bank_account_id
174: FROM ce_bank_accounts
175: WHERE NVL(end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
176: AND (currency_code = p_currency
177: or MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
178: AND account_owner_org_id = p_org_id) BA;

Line 183: FROM ce_bank_accounts ce_ba,

179: ELSIF p_org_type in ('OPERATING_UNIT', 'BUSINESS_GROUP') THEN
180: SELECT ce_ba.bank_account_id
181: BULK COLLECT
182: INTO x_bank_acct_ids
183: FROM ce_bank_accounts ce_ba,
184: ce_bank_acct_uses_all ce_bau
185: WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
186: AND NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
187: AND (ce_ba.currency_code = p_currency