SQL query return Boolean if data not exists in DB

 DB Table: 

Result Should be like below:

SQL Query: 

SELECT v.oid,
       (CASE WHEN EXISTS (SELECT 1
      FROM hrm.ap_award_type p
      WHERE p.oid = v.oid
     ) 
     THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT)
END) AS status
FROM (VALUES ('3b54e055-4c8a-40ea-a021-0e872cfc98c3'),
             ('caba5162'),
             ('10000'),
             ('b6d792aa-4bc3-4197-ae1e-f8c921f9ca8b')
) v(oid)