APPS.FV_CCR_UTIL_PVT dependencies on IBY_EXT_BANK_ACCOUNTS

Line 499: FROM iby_ext_bank_accounts

495: IS
496: CURSOR bank_acct_csr(p_branch_id NUMBER,p_acct_number VARCHAR2,
497: p_currency VARCHAR2) IS
498: SELECT ext_bank_account_id,bank_account_type
499: FROM iby_ext_bank_accounts
500: WHERE branch_id = p_branch_id
501: AND bank_account_num = p_acct_number
502: AND currency_code = p_currency
503: AND country_code = p_country_code;

Line 519: FROM iby_ext_bank_accounts

515:
516: IF(nvl(p_bank_account_id,0)<>0) THEN
517: SELECT bank_account_num,branch_id,bank_account_type
518: INTO l_bank_acct_num,l_bank_branch_id,l_bank_account_type
519: FROM iby_ext_bank_accounts
520: WHERE ext_bank_account_id=p_bank_account_id;
521: ELSE
522: l_bank_branch_id := null;
523: l_bank_acct_num:= null;

Line 2679: l_bank_account_type iby_ext_bank_accounts.bank_account_type%TYPE;

2675: p_bank_account_type VARCHAR2,
2676: x_return_status OUT NOCOPY VARCHAR2
2677: )
2678: IS
2679: l_bank_account_type iby_ext_bank_accounts.bank_account_type%TYPE;
2680: BEGIN
2681: --Bug 7038108
2682: IF p_bank_account_type = 'C' THEN
2683: l_bank_account_type := 'Checking';

Line 2689: UPDATE iby_ext_bank_accounts

2685: p_bank_account_type = 'S' THEN
2686: l_bank_account_type := 'Savings';
2687: END IF;
2688:
2689: UPDATE iby_ext_bank_accounts
2690: set BANK_ACCOUNT_TYPE = l_bank_account_type
2691: where EXT_BANK_ACCOUNT_ID = p_bank_account_id;
2692:
2693: x_return_status := fnd_api.G_RET_STS_SUCCESS;