namespace WiDAL.Query.Promotion
{
    public static class WiSubProcessCodeLookupQB
    {
        public const string GET_CODE_BY_ID = @"
            SELECT WISUBPROCESSCODE FROM WI.MWISUBPROCESS WHERE WISUBPROCESSID = @WiSubProcessId AND TENANTID = @TenantId";

        public const string GET_ID_BY_CODE = @"
            SELECT WISUBPROCESSID FROM WI.MWISUBPROCESS WHERE WISUBPROCESSCODE = @WiSubProcessCode AND TENANTID = @TenantId";
    }
}