View: dbo.Privilege_Requiring_Workpapers_View | |||
View definition | |||
-- Privileges to exclude from Workpapers if there's no Workpapers -- license. ----------------------------------------------------------- -- If this list changes set Firm.has_workpapers to true so -- if the user doesn't have a Workpapers license we'll react. ----------------------------------------------------------- CREATE VIEW dbo.Privilege_Requiring_Workpapers_View AS SELECT privilege_KEY = P.privilege_KEY FROM dbo.Privilege P WHERE privilege_KEY IN ( 706, -- ACS_Setup_FirmInfo_SecGroup_WP 707) -- ACS_Setup_FirmInfo_Staff_Sec_WP | |||