APPS.FV_CCR_UTIL_PVT dependencies on IBY_EXT_BANK_ACCOUNTS

Line 455: FROM iby_ext_bank_accounts

451: p_currency VARCHAR2) IS
452: --Bug8405987
453: SELECT ext_bank_account_id,
454: DECODE(UPPer(bank_account_type),'SAVINGS','S','CHECKING','C',bank_account_type)
455: FROM iby_ext_bank_accounts
456: WHERE branch_id = p_branch_id
457: AND bank_account_num = p_acct_number
458: AND currency_code = p_currency
459: AND country_code = p_country_code;

Line 482: FROM iby_ext_bank_accounts

478: SELECT bank_account_num,branch_id,
479: DECODE(UPPER(bank_account_type),'SAVINGS','S','CHECKING','C',bank_account_type)
480: INTO l_bank_acct_num,l_bank_branch_id,
481: l_bank_account_type
482: FROM iby_ext_bank_accounts
483: WHERE ext_bank_account_id=p_bank_account_id;
484: ELSE
485: l_bank_branch_id := null;
486: l_bank_acct_num:= null;

Line 2980: l_bank_account_type iby_ext_bank_accounts.bank_account_type%TYPE;

2976: p_bank_account_type VARCHAR2,
2977: x_return_status OUT NOCOPY VARCHAR2
2978: )
2979: IS
2980: l_bank_account_type iby_ext_bank_accounts.bank_account_type%TYPE;
2981: BEGIN
2982: --Bug 7038108
2983: IF p_bank_account_type = 'C' THEN
2984: l_bank_account_type := 'CHECKING';

Line 2990: UPDATE iby_ext_bank_accounts

2986: p_bank_account_type = 'S' THEN
2987: l_bank_account_type := 'SAVINGS';
2988: END IF;
2989:
2990: UPDATE iby_ext_bank_accounts
2991: set BANK_ACCOUNT_TYPE = l_bank_account_type
2992: where EXT_BANK_ACCOUNT_ID = p_bank_account_id;
2993:
2994: x_return_status := fnd_api.G_RET_STS_SUCCESS;