USP_DATALIST_OTHERPAYMENTMETHODCONFIGURATION

                create procedure dbo.USP_DATALIST_OTHERPAYMENTMETHODCONFIGURATION 
                as
                    set nocount on;

                    select
                        OTHERPAYMENTMETHODCODE.ID,
                        OTHERPAYMENTMETHODCODE.DESCRIPTION,
                        case when exists(select ID from dbo.NONDEPOSITABLEPAYMENTMETHOD
                                            where ID = OTHERPAYMENTMETHODCODE.ID) 
                            then 0
                            else 1
                            end as ISDEPOSITABLE
                    from dbo.OTHERPAYMENTMETHODCODE