APPS.FA_CUA_ASSET_WB_APIS_PKG dependencies on FA_ADDITIONS

Line 348: from fa_distribution_history fdh ,fa_hierarchy_distributions ihd,fa_additions fa

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

Line 418: v_asset_number fa_additions.asset_number%TYPE;

414: End get_rule_set_name;
415:
416: Function get_asset_number (x_id in number) return varchar2
417: is
418: v_asset_number fa_additions.asset_number%TYPE;
419: cursor C is
420: select asset_number
421: from fa_additions
422: where asset_id = x_id;

Line 421: from fa_additions

417: is
418: v_asset_number fa_additions.asset_number%TYPE;
419: cursor C is
420: select asset_number
421: from fa_additions
422: where asset_id = x_id;
423: Begin
424: open C;
425: fetch C into v_asset_number;