APPS.FA_CUA_ASSET_APIS dependencies on FA_ADDITIONS

Line 473: from fa_additions

469: ORDER BY 1;
470:
471: CURSOR C_get_cat_id IS
472: select asset_category_id
473: from fa_additions
474: where asset_id = x_asset_id;
475:
476: CURSOR C_get_lease_id IS
477: select lease_id

Line 478: from fa_additions

474: where asset_id = x_asset_id;
475:
476: CURSOR C_get_lease_id IS
477: select lease_id
478: from fa_additions
479: where asset_id = x_asset_id;
480:
481: CURSOR C_book_class IS
482: select book_class

Line 985: -- determine from fa_additions for that asset

981: -- use the cat_in value
982: if(nvl(x_cat_id_in,0) <> 0) then
983: v_cat_id := x_cat_id_in;
984: else -- if cat_id_in is null
985: -- determine from fa_additions for that asset
986: open C_get_cat_id;
987: fetch C_get_cat_id into v_cat_id;
988: close c_get_cat_id;
989:

Line 1526: , fa_additions a

1522: select count(*)
1523: into v_dist_count2
1524: from fa_distribution_history fmd
1525: , fa_hierarchy_distributions ihd
1526: , fa_additions a
1527: where fmd.asset_id = v_asset_attr_tab(i).asset_id
1528: and fmd.asset_id = a.asset_id
1529: and fmd.date_ineffective is null
1530: and ihd.dist_set_id = v_distribution_set_id_out

Line 1984: from fa_additions

1980: l_err_stage:= 'get asset_category_id';
1981: --dbms_output.put_line(l_err_stage);
1982: select asset_category_id
1983: into v_asset_cat_id
1984: from fa_additions
1985: where asset_id = p_asset_id;
1986:
1987: initialize_Gvariables;
1988: if p_attribute_name = 'CATEGORY' then