Determine if a Package Uses a Specific Path

SELECT 
    MIN(pfh.FULL_PATH) as FULL_PATH,
    p.NAME
FROM 
    [NameBDDEPM].[dbo].[PACKAGE_FILES_HASH] pfh
JOIN 
    [NameBDDEPM].[dbo].[PACKAGE_FILES] pf
ON 
    pfh.PACKAGE_FILES_HASH_IDN = pf.PACKAGE_FILES_HASH_IDN
JOIN 
    [NameBDDEPM].[dbo].[PACKAGE] p
ON 
    pf.PACKAGE_IDN = p.PACKAGE_IDN
WHERE 
    LOWER(pfh.FULL_PATH) LIKE '%NamePath%'
GROUP BY 
    p.NAME