DBA Data[Home] [Help]

APPS.IBY_PAYMENTMANAGERDB_PKG dependencies on CE_BANK_ACCOUNTS

Line 163: l_bank_id ce_bank_accounts_v.bank_id%TYPE;

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

Line 215: Retrieving the bank_id from ce_bank_accounts instead of

211: iby_debug_pub.add('debug pt 6',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
212:
213: /*
214: Bug 9462790: ROUTING FAILURE AT REMITTANCE LEVEL
215: Retrieving the bank_id from ce_bank_accounts instead of
216: ce_bank_accounts_v.(after discussion with CE team)
217: Org context was not setting properly in ce_bank_accounts_v.
218: Org context is already checked by AR in case of internal bank accounts
219: and thus not needed by IBY.

Line 216: ce_bank_accounts_v.(after discussion with CE team)

212:
213: /*
214: Bug 9462790: ROUTING FAILURE AT REMITTANCE LEVEL
215: Retrieving the bank_id from ce_bank_accounts instead of
216: ce_bank_accounts_v.(after discussion with CE team)
217: Org context was not setting properly in ce_bank_accounts_v.
218: Org context is already checked by AR in case of internal bank accounts
219: and thus not needed by IBY.
220: */

Line 217: Org context was not setting properly in ce_bank_accounts_v.

213: /*
214: Bug 9462790: ROUTING FAILURE AT REMITTANCE LEVEL
215: Retrieving the bank_id from ce_bank_accounts instead of
216: ce_bank_accounts_v.(after discussion with CE team)
217: Org context was not setting properly in ce_bank_accounts_v.
218: Org context is already checked by AR in case of internal bank accounts
219: and thus not needed by IBY.
220: */
221:

Line 224: FROM ce_bank_accounts

220: */
221:
222: IF (NOT p_int_bank_acct_id IS NULL) THEN
223: SELECT bank_id INTO l_bank_id
224: FROM ce_bank_accounts
225: WHERE (bank_account_id = p_int_bank_acct_id);
226: END IF;
227: iby_debug_pub.add('debug pt 1',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
228: --- *** R12 Note *** ---