DBA Data[Home] [Help]

APPS.FA_RECLASS_UTIL_PVT dependencies on DUAL

Line 152: from dual

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

Line 173: from dual

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: --