APPS.FA_CUA_ASSET_APIS dependencies on FA_ADDITIONS

Line 477: from fa_additions

473: ORDER BY 1;
474:
475: CURSOR C_get_cat_id IS
476: select asset_category_id
477: from fa_additions
478: where asset_id = x_asset_id;
479:
480: CURSOR C_get_lease_id IS
481: select lease_id

Line 482: from fa_additions

478: where asset_id = x_asset_id;
479:
480: CURSOR C_get_lease_id IS
481: select lease_id
482: from fa_additions
483: where asset_id = x_asset_id;
484:
485: CURSOR C_book_class IS
486: select book_class

Line 991: -- determine from fa_additions for that asset

987: -- use the cat_in value
988: if(nvl(x_cat_id_in,0) <> 0) then
989: v_cat_id := x_cat_id_in;
990: else -- if cat_id_in is null
991: -- determine from fa_additions for that asset
992: open C_get_cat_id;
993: fetch C_get_cat_id into v_cat_id;
994: close c_get_cat_id;
995:

Line 1537: , fa_additions a

1533: select count(*)
1534: into v_dist_count2
1535: from fa_distribution_history fmd
1536: , fa_hierarchy_distributions ihd
1537: , fa_additions a
1538: where fmd.asset_id = v_asset_attr_tab(i).asset_id
1539: and fmd.asset_id = a.asset_id
1540: and fmd.date_ineffective is null
1541: and ihd.dist_set_id = v_distribution_set_id_out

Line 2004: from fa_additions

2000: l_err_stage:= 'get asset_category_id';
2001: --dbms_output.put_line(l_err_stage);
2002: select asset_category_id
2003: into v_asset_cat_id
2004: from fa_additions
2005: where asset_id = p_asset_id;
2006:
2007: initialize_Gvariables;
2008: if p_attribute_name = 'CATEGORY' then