APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_INST_TRANSACTIONS_V

Line 10932: FROM csi_inst_transactions_v

10928: BEGIN
10929: /*Commenting for bug 5615162 added more code below
10930: SELECT 'x'
10931: INTO l_temp
10932: FROM csi_inst_transactions_v
10933: WHERE instance_id=p_instance_id
10934: AND source_transaction_date > p_source_transaction_date
10935: AND transaction_id <> p_transaction_id
10936: AND ROWNUM=1;

Line 11229: FROM csi_inst_transactions_v

11225: -- srramakr changed to source_transaction_date instead of transaction_date (3804960)
11226: BEGIN
11227: SELECT 'x'
11228: INTO l_temp
11229: FROM csi_inst_transactions_v
11230: WHERE instance_id=p_instance_id
11231: AND source_transaction_date > p_source_transaction_date
11232: AND transaction_id <> p_transaction_id
11233: AND ROWNUM=1;

Line 19083: FROM csi_inst_transactions_v

19079: l_temp_date:= p_instance_rec.active_end_date;
19080: BEGIN
19081: SELECT 'x'
19082: INTO l_temp
19083: FROM csi_inst_transactions_v
19084: WHERE instance_id=l_curr_instance_rec.instance_id
19085: AND transaction_date>p_instance_rec.active_end_date
19086: AND ROWNUM=1;
19087:

Line 20201: FROM csi_inst_transactions_v

20197: l_temp_date:= p_instance_rec.active_end_date;
20198: BEGIN
20199: SELECT MAX(transaction_date)
20200: INTO l_txn_date
20201: FROM csi_inst_transactions_v
20202: WHERE instance_id=p_instance_rec.instance_id
20203: AND transaction_date>p_instance_rec.active_end_date;
20204:
20205: IF l_txn_date IS NOT NULL