UFN_PROGRAMGROUP_GETPRICES

      create function dbo.UFN_PROGRAMGROUP_GETPRICES
              (
                  @PROGRAMGROUPID uniqueidentifier
              ) returns table
              as
                  return
                  select
                      PROGRAMGROUPPRICE.ID,
              PROGRAMGROUPPRICE.COMBINATIONPRICETYPEID,
              PRICETYPECODE.DESCRIPTION as PRICETYPE,
              PROGRAMGROUPPRICE.FACEPRICE,
                      COMBINATIONPRICETYPE.SEQUENCE
                  from
                      dbo.PROGRAMGROUPPRICE
            inner join dbo.PROGRAMGROUP on
              PROGRAMGROUP.ID = PROGRAMGROUPPRICE.PROGRAMGROUPID
                  inner join dbo.COMBINATIONPRICETYPE on
              PROGRAMGROUPPRICE.COMBINATIONPRICETYPEID = COMBINATIONPRICETYPE.ID
                  left join dbo.PRICETYPECODE on 
                      PRICETYPECODE.ID = COMBINATIONPRICETYPE.PRICETYPECODEID
                  where
              PROGRAMGROUP.ID = @PROGRAMGROUPID and
              PRICETYPECODE.ACTIVE = 1