UFN_FINANCIALINSTITUTIONID_EXISTS

create function dbo.UFN_FINANCIALINSTITUTIONID_EXISTS
(
    @FINANCIALINSTITUTIONID uniqueidentifier
)
returns bit
with execute as caller
as 
begin

    declare @FICOUNT int;
    declare @BATCHFICOUNT int;

    select
        @FICOUNT = count(ID)
    from
        dbo.FINANCIALINSTITUTION
    where
        FINANCIALINSTITUTION.ID = @FINANCIALINSTITUTIONID

    select
        @BATCHFICOUNT = count(ID)
    from
        dbo.BATCHREVENUEFINANCIALINSTITUTION
    where
        BATCHREVENUEFINANCIALINSTITUTION.ID = @FINANCIALINSTITUTIONID

    if @FICOUNT > 0 or @BATCHFICOUNT > 0
        return 1;

    return 0;

end