spLoadRecord_ClassYearNotes

CREATE   procedure [dbo].[spLoadRecord_ClassYearNotes] (
    @PKID int 
)
as
BEGIN
    set nocount on
    select cyn.ID, cyn.ClientClassYearsID, cyn.ClassNote, cyn.OwnerID, cyn.IsApproved, cyn.ApprovedByID, 
    cyn.ApprovedDate,    cyn.PublishDate, cyn.ModifiedDate, cyn.ExpireDate, cyn.DateLastChanged,
    ccy.[Name], ccy.Guid ClassYearsGuid, dbo.fnGetRaisersEdgeRecordIDFromPeopleID(cyn.BackOfficeSystemPeopleID) RaisersEdgeRecordID,
    cyn.FirstName, cyn.LastName
    from ClassYearNotes cyn
    inner join ClientClassYears ccy on ccy.ID = cyn.ClientClassYearsID
    where cyn.ID = @PKID
END