APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on CE_BANK_ACCOUNTS_V

Line 161: l_bank_id ce_bank_accounts_v.bank_id%TYPE;

157: -- *** R12 Modification *** ---
158: -- Added variables l_instr_type and l_mpayeeid
159: l_instr_type iby_trxn_summaries_all.instrtype%TYPE;
160: l_mpayeeid iby_payee.mpayeeid%TYPE;
161: l_bank_id ce_bank_accounts_v.bank_id%TYPE;
162:
163: BEGIN
164: iby_debug_pub.add('ENTER',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
165:

Line 212: FROM ce_bank_accounts_v

208: WHERE a.payeeid = p_payee_id;
209: iby_debug_pub.add('debug pt 6',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
210: IF (NOT p_int_bank_acct_id IS NULL) THEN
211: SELECT bank_id INTO l_bank_id
212: FROM ce_bank_accounts_v
213: WHERE (bank_account_id = p_int_bank_acct_id);
214: END IF;
215: iby_debug_pub.add('debug pt 1',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
216: --- *** R12 Note *** ---