SELECT
  A.ProductCategory,
  A.AttendanceTypeID,
  A.AppointmentType,
  A.TypeDescription,
  A.UseTypeRate,
  A.InCoverRate,
  A.OutOfCoverRate,
  A.AdhocRate,
  A.IsActive,
  @pNavFields
FROM
  tbAppointmentTypes AS A
WHERE
  (A.AttendanceTypeID = @nAttendanceTypeID)
