Untitled

   SELECT 1 
  FROM dual 
 WHERE EXISTS( 
    SELECT 1
         FROM   PM_ACTION_TAB
         WHERE   org_contract = User_Allowed_Site_API.Authorized(org_contract)
         AND  rowstate IN ('Active','Preliminary') 
         AND   equipment_object_seq = equipment_object_seq_ );