SELECT
vtsp.PackageID,
vtsp.Name
FROM
v_taskSequencePackage vtsp
INNER JOIN v_TaskSequenceReferencesInfo vtsri
	ON vtsp.PackageID = vtsri.PackageID
WHERE
vtsri.ReferencePackageID = @pkgid