331:
332: if (FA_CUA_ASSET_APIS.g_distribution_overide_allowed = 'N') and ( x_mode = 'SHOWERR') then
333:
334: select count(*) into h_dist_count
335: from fa_distribution_history
336: where asset_id = x_Asset_id
337: and book_type_code = v_book_type_code
338: and date_ineffective is null;
339:
344: if h_dist_count <> 0 then
345:
346: select count(*)
347: into h_dist_count3
348: from fa_distribution_history fdh ,fa_hierarchy_distributions ihd,fa_additions fa
349: where fa.asset_id = x_Asset_id
350: and fdh.asset_id = x_Asset_id
351: and fdh.date_ineffective is null
352: and fdh.book_type_code = v_book_type_code