APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_ITEM_INSTANCES_H

Line 1043: FROM csi_item_instances_h

1039: --for the same instance_id
1040: BEGIN
1041: SELECT 'Y'
1042: INTO l_create_event_called
1043: FROM csi_item_instances_h
1044: WHERE instance_id = p_instance_rec.instance_id
1045: AND new_accounting_class_code = 'CUST_PROD'
1046: AND transaction_id <> p_txn_rec.transaction_id
1047: AND ROWNUM = 1;

Line 1537: FROM csi_item_instances_h

1533: IF l_inst_id is not null THEN
1534: csi_gen_utility_pvt.put_line('l_inst_id is not null');
1535: SELECT 'Y'
1536: INTO l_create_event_called
1537: FROM csi_item_instances_h
1538: WHERE instance_id = l_inst_id
1539: AND new_accounting_class_code = 'CUST_PROD'
1540: AND ROWNUM = 1;
1541: ELSE

Line 1544: FROM csi_item_instances_h

1540: AND ROWNUM = 1;
1541: ELSE
1542: SELECT 'Y'
1543: INTO l_create_event_called
1544: FROM csi_item_instances_h
1545: WHERE instance_id = p_instance_rec.instance_id
1546: AND new_accounting_class_code = 'CUST_PROD'
1547: AND ROWNUM = 1;
1548: END IF;