APPS.CSI_INV_HZ_PKG dependencies on CSI_INSTALL_PARAMETERS

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