148: if p_lease_id is not null then -- fix for bug 3507682
149: v_count := 0;
150: -- using count(*) instead of 1 as it throwing no data found. Fix for 8974754
151: select count(*) into v_count
152: from dual
153: where exists ( select 'x'
154: from fa_additions a,
155: fa_categories b
156: where a.asset_id = p_asset_id
169: --
170: v_count:= 0;
171: -- using count(*) instead of 1 as it throwing no data found. Fix for 8974754
172: select count(*) into v_count
173: from dual
174: where exists ( select 'x'
175: from fa_leases
176: where lease_id = p_lease_id );
177: --