UFN_MKTMARKETINGPLAN_GETEXPENSELIST

CREATE function dbo.[UFN_MKTMARKETINGPLAN_GETEXPENSELIST]
(
  @MARKETINGPLANITEMID uniqueidentifier
)
/*
Returns a table of expense items that have been assigned to the given MARKETINGPLANITEMID
*/
returns table
as
  return (select
        M.ID,
        M.EXPENSECATEGORYCODEID,
        M.EXPENSETYPECODE,
        M.AMOUNT,
        M.SEQUENCE
      from
        dbo.MKTMARKETINGPLANITEMEXPENSE M
      where
        M.MARKETINGPLANITEMID = @MARKETINGPLANITEMID);