SELECT
  A.ProductCategory,
  A.AttendanceTypeID,
  A.AppointmentType,
  A.TypeDescription,
  A.BillingRule,
  A.UnitOfMeasureID,
  A.IsService,
  A.IsClientMatter,
  A.AlwaysAllowed,
  A.IsActive,
  A.LeadTimeApplies,
  A.UseTypeRate,
  @pNavFields
FROM
  tbAppointmentTypes AS A
WHERE
  (A.AttendanceTypeID = @nAttendanceTypeID)
