APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_IP_ACCOUNTS_H

Line 1164: select CSI_IP_ACCOUNTS_H_S.nextval

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

Line 4398: INSERT INTO CSI_IP_ACCOUNTS_H(

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

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

8092: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
8093: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8094: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
8095: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8096: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);
8097: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8098: DELETE FROM CSI_I_ORG_ASSIGNMENTS_H WHERE transaction_id = l_del_txn_tbl(j);
8099: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
8100: DELETE FROM CSI_I_PRICING_ATTRIBS_H WHERE transaction_id = l_del_txn_tbl(j);