APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_INTERMEDIARY_ACCTS

Line 3251: INSERT INTO IBY_INTERMEDIARY_ACCTS(

3247: check_mandatory('Bank Account Id', p_intermed_acct_rec.bank_account_id);
3248:
3249: -- insert into IBY_INTERMEDIATE_ACCTS
3250:
3251: INSERT INTO IBY_INTERMEDIARY_ACCTS(
3252: INTERMEDIARY_ACCT_ID,
3253: LAST_UPDATE_DATE,
3254: LAST_UPDATED_BY,
3255: LAST_UPDATE_LOGIN,

Line 3271: IBY_INTERMEDIARY_ACCTS_S.nextval,

3267: IBAN,
3268: COMMENTS,
3269: OBJECT_VERSION_NUMBER)
3270: VALUES (
3271: IBY_INTERMEDIARY_ACCTS_S.nextval,
3272: sysdate,
3273: NVL(FND_GLOBAL.user_id,-1),
3274: NVL(FND_GLOBAL.login_id, -1),
3275: sysdate,

Line 3359: FROM IBY_INTERMEDIARY_ACCTS

3355:
3356: -- Get Object Version Number
3357: CURSOR c_ovn IS
3358: SELECT object_version_number
3359: FROM IBY_INTERMEDIARY_ACCTS
3360: WHERE intermediary_acct_id = p_intermed_acct_rec.intermediary_acct_id;
3361:
3362: l_old_ovn NUMBER(15);
3363:

Line 3412: UPDATE IBY_INTERMEDIARY_ACCTS

3408: RAISE fnd_api.g_exc_error;
3409: END IF;
3410:
3411: -- update the table IBY_INTERMEDIARY_ACCOUNTS
3412: UPDATE IBY_INTERMEDIARY_ACCTS
3413: SET country_code = p_intermed_acct_rec.country_code,
3414: bank_name = p_intermed_acct_rec.bank_name,
3415: city = p_intermed_acct_rec.city,
3416: bank_code = p_intermed_acct_rec.bank_code,