APPS.CE_LEVELING_UTILS dependencies on CE_BANK_ACCOUNTS

Line 272: l_from_bank_account_id CE_BANK_ACCOUNTS.bank_Account_id%TYPE;

268: l_result VARCHAR2(7);
269: l_msg_count NUMBER;
270: l_authorization_bat CE_CASHPOOLS.authorization_bat%TYPE;
271: l_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
272: l_from_bank_account_id CE_BANK_ACCOUNTS.bank_Account_id%TYPE;
273: l_to_bank_Account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
274:
275: BEGIN
276:

Line 273: l_to_bank_Account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;

269: l_msg_count NUMBER;
270: l_authorization_bat CE_CASHPOOLS.authorization_bat%TYPE;
271: l_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
272: l_from_bank_account_id CE_BANK_ACCOUNTS.bank_Account_id%TYPE;
273: l_to_bank_Account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
274:
275: BEGIN
276:
277: l_bat_profile := FND_PROFILE.VALUE('CE_BANK_ACCOUNT_TRANSFERS');

Line 407: FROM ce_bank_accounts

403:
404: ELSE -- bat_profile = 'XTR'
405: SELECT account_owner_org_id
406: INTO l_from_le_id
407: FROM ce_bank_accounts
408: WHERE bank_account_id = X_from_bank_account_id;
409:
410: SELECT account_owner_org_id
411: INTO l_to_le_id

Line 412: FROM ce_bank_accounts

408: WHERE bank_account_id = X_from_bank_account_id;
409:
410: SELECT account_owner_org_id
411: INTO l_to_le_id
412: FROM ce_bank_accounts
413: WHERE bank_account_id = X_to_bank_account_id;
414:
415: -- Call the relevant XTR wrapper API based on the deal type
416: IF l_from_le_id = l_to_le_id THEN -- Inter-Account Transfer (IAC)

Line 672: UPDATE ce_bank_accounts

668: p_round_factor VARCHAR2,
669: p_round_rule VARCHAR2) IS
670: BEGIN
671:
672: UPDATE ce_bank_accounts
673: SET min_target_balance = nvl(p_min_target_balance,to_number(null)),
674: max_target_balance = nvl(p_max_target_balance,to_number(null)),
675: cashpool_min_payment_amt = nvl(p_min_payment_amt,0),
676: cashpool_min_receipt_amt = nvl(p_min_receipt_amt,0),

Line 708: UPDATE ce_bank_accounts

704: p_remittance_message2 VARCHAR2,
705: p_remittance_message3 VARCHAR2) IS
706: BEGIN
707:
708: UPDATE ce_bank_accounts
709: SET pool_payment_method_code = p_payment_method_code,
710: pool_bank_charge_bearer_code = p_bank_charge_bearer_code,
711: pool_payment_reason_code = p_payment_reason_code,
712: pool_payment_reason_comments = p_payment_reason_comments,

Line 815: FROM ce_bank_accounts

811: l_error_flag := 'N';
812:
813: SELECT bank_account_id
814: INTO l_offset_bank_account_id
815: FROM ce_bank_accounts
816: WHERE bank_account_num = p_offset_bank_account_num;
817:
818: IF p_trx_type = 'SWEEP_IN' THEN -- Sweep in
819: SELECT cashpool_id, type