APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_INST_TRANSACTIONS_V

Line 11221: FROM csi_inst_transactions_v

11217: BEGIN
11218: /*Commenting for bug 5615162 added more code below
11219: SELECT 'x'
11220: INTO l_temp
11221: FROM csi_inst_transactions_v
11222: WHERE instance_id=p_instance_id
11223: AND source_transaction_date > p_source_transaction_date
11224: AND transaction_id <> p_transaction_id
11225: AND ROWNUM=1;

Line 11518: FROM csi_inst_transactions_v

11514: -- srramakr changed to source_transaction_date instead of transaction_date (3804960)
11515: BEGIN
11516: SELECT 'x'
11517: INTO l_temp
11518: FROM csi_inst_transactions_v
11519: WHERE instance_id=p_instance_id
11520: AND source_transaction_date > p_source_transaction_date
11521: AND transaction_id <> p_transaction_id
11522: AND ROWNUM=1;

Line 19580: FROM csi_inst_transactions_v

19576: l_temp_date:= p_instance_rec.active_end_date;
19577: BEGIN
19578: SELECT 'x'
19579: INTO l_temp
19580: FROM csi_inst_transactions_v
19581: WHERE instance_id=l_curr_instance_rec.instance_id
19582: AND transaction_date>p_instance_rec.active_end_date
19583: AND ROWNUM=1;
19584:

Line 20705: FROM csi_inst_transactions_v

20701: l_temp_date:= p_instance_rec.active_end_date;
20702: BEGIN
20703: SELECT MAX(transaction_date)
20704: INTO l_txn_date
20705: FROM csi_inst_transactions_v
20706: WHERE instance_id=p_instance_rec.instance_id
20707: AND transaction_date>p_instance_rec.active_end_date;
20708:
20709: IF l_txn_date IS NOT NULL

Line 20714: -- by leaving future transactions in csi_inst_transactions_v, which was causing an

20710: THEN
20711:
20712: -- Added for bug#14559620
20713: -- Standard Concurrent Job: End-dated Instances Process expiring child instances before parent
20714: -- by leaving future transactions in csi_inst_transactions_v, which was causing an
20715: -- error, added below code to over come this situation
20716: l_parent_found := 'Y';
20717: IF p_txn_rec.transaction_type_id = 5 THEN
20718: BEGIN