USP_SIMPLEDATALIST_PDACCOUNTCODEMAPCURRENCY

            create procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTCODEMAPCURRENCY(
              @ID uniqueidentifier
            ) as
                select VALUE, LABEL
                from
                    ((select 
                        CURRENCY.ID as VALUE, 
                        CURRENCY.NAME as LABEL
                        from dbo.CURRENCY
                        inner join dbo.CURRENCYSETTRANSACTIONCURRENCY on CURRENCY.ID = CURRENCYSETTRANSACTIONCURRENCY.CURRENCYID
                        inner join dbo.PDACCOUNTSYSTEM on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSETTRANSACTIONCURRENCY.CURRENCYSETID
                        where PDACCOUNTSYSTEM.ID = @ID)

                    union 
                    (select '99999999-9999-9999-9999-999999999999', 'All currencies')) V1
                order by LABEL