APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_ITEM_INSTANCES_H

Line 3272: SELECT csi_item_instances_h_s.NEXTVAL

3268: IS
3269: l_csi_item_instance_h_id NUMBER;
3270:
3271: BEGIN
3272: SELECT csi_item_instances_h_s.NEXTVAL
3273: INTO l_csi_item_instance_h_id
3274: FROM dual;
3275: RETURN l_csi_item_instance_h_id;
3276: EXCEPTION

Line 5066: from csi_item_instances_h

5062: l_min_txn_id := NULL;
5063: l_src_txn_date := NULL;
5064: select min(transaction_id)
5065: into l_min_txn_id
5066: from csi_item_instances_h
5067: where instance_id = p_instance_rec.instance_id
5068: and creation_date = (select min(creation_date) from csi_item_instances_h
5069: where instance_id = p_instance_rec.instance_id
5070: );

Line 5068: and creation_date = (select min(creation_date) from csi_item_instances_h

5064: select min(transaction_id)
5065: into l_min_txn_id
5066: from csi_item_instances_h
5067: where instance_id = p_instance_rec.instance_id
5068: and creation_date = (select min(creation_date) from csi_item_instances_h
5069: where instance_id = p_instance_rec.instance_id
5070: );
5071: --
5072: IF l_min_txn_id IS NOT NULL THEN