namespace WiDAL.Query.Promotion
{
    public static class DepartmentCodeLookupQB
    {
        public const string GET_CODE_BY_ID = @"
            SELECT DEPARTMENTCODE FROM MDEPARTMENT WHERE DEPARTMENTID = @DepartmentId AND TENANTID = @TenantId";

        public const string GET_ID_BY_CODE = @"
            SELECT DEPARTMENTID FROM MDEPARTMENT WHERE DEPARTMENTCODE = @DepartmentCode AND TENANTID = @TenantId";
    }
}