USP_DATALIST_REVENUEOPPORTUNITYSINGLECANDIDATE

                CREATE procedure dbo.USP_DATALIST_REVENUEOPPORTUNITYSINGLECANDIDATE
                (
                    @OPPORTUNITYID uniqueidentifier = null
                ) as
                    set nocount on;

                    select
                        OPPORTUNITY.ID,
                        NF.NAME,
                        OPPORTUNITY.TRANSACTIONASKAMOUNT,
                        OPPORTUNITY.ASKDATE,
                        OPPORTUNITY.STATUS,
                        OPPORTUNITY.TRANSACTIONCURRENCYID
                    from
                        dbo.OPPORTUNITY
                        inner join dbo.PROSPECTPLAN on OPPORTUNITY.PROSPECTPLANID = PROSPECTPLAN.ID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PROSPECTPLAN.PROSPECTID) NF
                    where 
                        OPPORTUNITY.ID = @OPPORTUNITYID and 
                        OPPORTUNITY.STATUSCODE in (1,2,3)