APPS.IBY_EXT_BANKACCT_PUB dependencies on IBY_INTERMEDIARY_ACCTS

Line 3890: INSERT INTO IBY_INTERMEDIARY_ACCTS(

3886: check_mandatory('IBY_BANKACCT_ID_FIELD', p_intermed_acct_rec.bank_account_id);
3887:
3888: -- insert into IBY_INTERMEDIATE_ACCTS
3889:
3890: INSERT INTO IBY_INTERMEDIARY_ACCTS(
3891: INTERMEDIARY_ACCT_ID,
3892: LAST_UPDATE_DATE,
3893: LAST_UPDATED_BY,
3894: LAST_UPDATE_LOGIN,

Line 3911: IBY_INTERMEDIARY_ACCTS_S.nextval,

3907: IBAN,
3908: COMMENTS,
3909: OBJECT_VERSION_NUMBER)
3910: VALUES (
3911: IBY_INTERMEDIARY_ACCTS_S.nextval,
3912: sysdate,
3913: NVL(FND_GLOBAL.user_id,-1),
3914: NVL(FND_GLOBAL.login_id, -1),
3915: sysdate,

Line 4004: FROM IBY_INTERMEDIARY_ACCTS

4000:
4001: -- Get Object Version Number
4002: CURSOR c_ovn IS
4003: SELECT object_version_number
4004: FROM IBY_INTERMEDIARY_ACCTS
4005: WHERE intermediary_acct_id = p_intermed_acct_rec.intermediary_acct_id;
4006:
4007: l_old_ovn NUMBER(15);
4008:

Line 4059: UPDATE IBY_INTERMEDIARY_ACCTS

4055: RAISE fnd_api.g_exc_error;
4056: END IF;
4057:
4058: -- update the table IBY_INTERMEDIARY_ACCOUNTS
4059: UPDATE IBY_INTERMEDIARY_ACCTS
4060: SET country_code = p_intermed_acct_rec.country_code,
4061: bank_name = p_intermed_acct_rec.bank_name,
4062: city = p_intermed_acct_rec.city,
4063: bank_code = p_intermed_acct_rec.bank_code,