APPS.CSI_INV_HZ_PKG dependencies on CSI_ITEM_INSTANCES

Line 1233: FROM csi_item_instances

1229: END IF;
1230:
1231: SELECT object_version_number
1232: into l_src_instance_header_tbl(i).object_version_number
1233: FROM csi_item_instances
1234: WHERE instance_id = l_src_instance_header_tbl(i).instance_id;
1235:
1236: IF (l_debug > 0) THEN
1237: csi_t_gen_utility_pvt.add('Current Object Version after check and break :'||l_src_instance_header_tbl(i).object_version_number);

Line 1248: SELECT 'Y' INTO l_is_internal FROM csi_item_instances cii, csi_install_parameters ci

1244: IF l_src_instance_header_tbl.count = 1 THEN -- Records found so update either Serialized or Non Serialized
1245: --Added for Bug 13460798
1246: l_is_internal := 'N';
1247: BEGIN
1248: SELECT 'Y' INTO l_is_internal FROM csi_item_instances cii, csi_install_parameters ci
1249: WHERE cii.OWNER_PARTY_ID = ci.INTERNAL_PARTY_ID
1250: AND cii.instance_id = l_src_instance_header_tbl(i).instance_id;
1251: EXCEPTION
1252: WHEN OTHERS THEN