APPS.XTR_REPLICATE_BANK_BALANCES dependencies on CE_BANK_ACCOUNTS

Line 814: l_int_schedule_id ce_bank_accounts.interest_schedule_id%TYPE ;

810: l_duplicate NUMBER;
811: l_return_error VARCHAR2(30);
812: l_authorised VARCHAR2(1);
813: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE ;
814: l_int_schedule_id ce_bank_accounts.interest_schedule_id%TYPE ;
815: l_pricing_model xtr_bank_accounts.pricing_model%TYPE;
816:
817:
818: -- Check whether the portfolio code exists for the bank account for which balacnes

Line 853: From ce_bank_accounts

849: /* Bug 5346243 */
850:
851: Cursor c_int_schedule ( l_ce_bank_account_id Number ) Is
852: Select interest_schedule_id
853: From ce_bank_accounts
854: Where bank_account_id = l_ce_bank_account_id ;
855:
856:
857:

Line 2244: FROM ce_bank_accounts a,

2240:
2241: x_return_status := FND_API.G_RET_STS_SUCCESS;
2242:
2243: SELECT b.funding_limit_code into p_funding_limit_code
2244: FROM ce_bank_accounts a,
2245: ce_bank_acct_uses_all b
2246: WHERE a.bank_account_id=b.bank_account_id
2247: and a.bank_account_id= p_bank_accont_id
2248: AND b.xtr_use_enable_flag='Y';