UFN_PROGRAM_GETPRICES

        CREATE function dbo.UFN_PROGRAM_GETPRICES
        (
            @PROGRAMID uniqueidentifier
        ) returns table
        as
            return
            select
                PROGRAMPRICE.ID,
                PRICETYPECODEID,
                FACEPRICE,
                PROGRAMPRICE.SEQUENCE
            from
                dbo.PROGRAMPRICE
            left join dbo.PRICETYPECODE on 
                PRICETYPECODE.ID = PROGRAMPRICE.PRICETYPECODEID
            where
                PROGRAMID = @PROGRAMID and
                PRICETYPECODE.ACTIVE = 1