APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_IP_ACCOUNTS_H

Line 1161: select CSI_IP_ACCOUNTS_H_S.nextval

1157: l_count NUMBER;
1158: l_hist_id NUMBER;
1159: BEGIN
1160: l_count := p_acct_hist_tbl.count + 1;
1161: select CSI_IP_ACCOUNTS_H_S.nextval
1162: into l_hist_id
1163: from sys.dual;
1164: --
1165: p_acct_hist_tbl(l_count).IP_ACCOUNT_HISTORY_ID := l_hist_id;

Line 4395: INSERT INTO CSI_IP_ACCOUNTS_H(

4391: --
4392: l_ctr := l_acct_hist_rec_tab.ip_account_history_id.count;
4393: --
4394: FORALL i in 1 .. l_ctr
4395: INSERT INTO CSI_IP_ACCOUNTS_H(
4396: IP_ACCOUNT_HISTORY_ID,
4397: IP_ACCOUNT_ID,
4398: TRANSACTION_ID,
4399: OLD_PARTY_ACCOUNT_ID,

Line 7559: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);

7555: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
7556: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7557: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
7558: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7559: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);
7560: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7561: DELETE FROM CSI_I_ORG_ASSIGNMENTS_H WHERE transaction_id = l_del_txn_tbl(j);
7562: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7563: DELETE FROM CSI_I_PRICING_ATTRIBS_H WHERE transaction_id = l_del_txn_tbl(j);