/* Formatted on 11/13/2020 3:34:13 PM (QP5 v5.185.11230.41888) */
SELECT MAX (1) d
  FROM AHS_DATABASE d
 WHERE     d.database_name = UPPER (:P721_DATABASE_NAME)
       AND EXISTS
              (SELECT 1
                 FROM self_service_privilege s
                WHERE     s.GRANTEE = :APP_USER
                      AND s.PRIVILEGE_TYPE = 'ZT_SQL_EXEC'
                      AND :P720_STMT_SCRIPT LIKE s.PRIVILEGE_KEY2
                      AND d.database_name LIKE s.PRIVILEGE_KEY1
               UNION ALL
               SELECT 1
                 FROM zt_privilege_group_detail pg, self_service_privilege s
                WHERE     pg.USERNAME = :APP_USER
                      AND s.PRIVILEGE_TYPE = 'ZT_SQL_EXEC'
                      AND :P720_STMT_SCRIPT LIKE s.PRIVILEGE_KEY2
                      AND s.GRANTEE = pg.PRIVILEGE_GROUP
                      AND d.database_name LIKE s.PRIVILEGE_KEY1
               UNION ALL
               SELECT 1
                 FROM self_service_privilege s, database_lists pd
                WHERE     :APP_USER LIKE s.GRANTEE
                      AND s.PRIVILEGE_TYPE = 'ZT_SQL_EXEC'
                      AND :P720_STMT_SCRIPT LIKE s.PRIVILEGE_KEY2
                      AND pd.list_name = s.PRIVILEGE_KEY1
                      AND pd.list_type = 'PRIV_LIST'
                      AND d.database_name = pd.database_name
               UNION ALL
               SELECT 1
                 FROM zt_privilege_group_detail pg,
                      self_service_privilege s,
                      database_lists pd
                WHERE     pg.USERNAME = :APP_USER
                      AND s.PRIVILEGE_TYPE = 'ZT_SQL_EXEC'
                      AND :P720_STMT_SCRIPT LIKE s.PRIVILEGE_KEY2
                      AND s.GRANTEE = pg.PRIVILEGE_GROUP
                      AND pd.list_name = s.PRIVILEGE_KEY1
                      AND pd.list_type = 'PRIV_LIST'
                      AND d.database_name = pd.database_name)