APPS.CE_LEVELING_UTILS dependencies on CE_BANK_ACCOUNTS

Line 289: l_from_bank_account_id CE_BANK_ACCOUNTS.bank_Account_id%TYPE;

285: l_result VARCHAR2(7);
286: l_msg_count NUMBER;
287: l_authorization_bat CE_CASHPOOLS.authorization_bat%TYPE;
288: l_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
289: l_from_bank_account_id CE_BANK_ACCOUNTS.bank_Account_id%TYPE;
290: l_to_bank_Account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
291:
292: --
293: -- 16462154: Added

Line 290: l_to_bank_Account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;

286: l_msg_count NUMBER;
287: l_authorization_bat CE_CASHPOOLS.authorization_bat%TYPE;
288: l_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
289: l_from_bank_account_id CE_BANK_ACCOUNTS.bank_Account_id%TYPE;
290: l_to_bank_Account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
291:
292: --
293: -- 16462154: Added
294: --

Line 464: FROM ce_bank_accounts

460: ELSE -- bat_profile = 'XTR'
461: log_msg(l_debug_proc,'Creating XTR Deal ....');
462: SELECT account_owner_org_id
463: INTO l_from_le_id
464: FROM ce_bank_accounts
465: WHERE bank_account_id = X_from_bank_account_id;
466:
467: SELECT account_owner_org_id
468: INTO l_to_le_id

Line 469: FROM ce_bank_accounts

465: WHERE bank_account_id = X_from_bank_account_id;
466:
467: SELECT account_owner_org_id
468: INTO l_to_le_id
469: FROM ce_bank_accounts
470: WHERE bank_account_id = X_to_bank_account_id;
471:
472: -- Call the relevant XTR wrapper API based on the deal type
473: IF l_from_le_id = l_to_le_id

Line 755: UPDATE ce_bank_accounts

751: p_round_factor VARCHAR2,
752: p_round_rule VARCHAR2
753: ) IS
754: BEGIN
755: UPDATE ce_bank_accounts
756: SET min_target_balance = nvl(p_min_target_balance,to_number(null)),
757: max_target_balance = nvl(p_max_target_balance,to_number(null)),
758: cashpool_min_payment_amt = nvl(p_min_payment_amt,0),
759: cashpool_min_receipt_amt = nvl(p_min_receipt_amt,0),

Line 791: UPDATE ce_bank_accounts

787: p_remittance_message2 VARCHAR2,
788: p_remittance_message3 VARCHAR2
789: ) IS
790: BEGIN
791: UPDATE ce_bank_accounts
792: SET pool_payment_method_code = p_payment_method_code,
793: pool_bank_charge_bearer_code = p_bank_charge_bearer_code,
794: pool_payment_reason_code = p_payment_reason_code,
795: pool_payment_reason_comments = p_payment_reason_comments,

Line 902: FROM ce_bank_accounts cba, ce_cashpools cp, ce_cashpool_sub_accts cps

898:
899: -- Bug 8489586 Start
900: SELECT DISTINCT cps. account_id -- Bug 14512843: Added DISTINCT
901: INTO l_offset_bank_account_id
902: FROM ce_bank_accounts cba, ce_cashpools cp, ce_cashpool_sub_accts cps
903: WHERE cba.bank_account_id in(cp.conc_account_id, -- Bug 14512483 Modified clause
904: cp.inv_conc_account_id,
905: cp.fund_conc_account_id)
906: AND cp.cashpool_id = cps.cashpool_id

Line 910: FROM ce_bank_accounts

906: AND cp.cashpool_id = cps.cashpool_id
907: AND cps.type in ('ACCT','CONC','INV','FUND') /* 14140123 */
908: AND cps.account_id IN
909: (SELECT bank_account_id
910: FROM ce_bank_accounts
911: WHERE bank_account_num = p_offset_bank_account_num);
912: -- Bug 8489586 End
913: log_msg(l_debug_proc,'l_offset_bank_account_id='||l_offset_bank_account_id);
914: log_msg(l_debug_proc,'p_trx_type='||p_trx_type);