DBA Data[Home] [Help]

APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_ASSET_HISTORY

Line 639: from fa_asset_history

635:
636: -- +++++ Get Current Unit of Group Asset +++++
637: CURSOR c_get_unit (c_asset_id number) is
638: select units
639: from fa_asset_history
640: where asset_id = c_asset_id
641: and transaction_header_id_out is null;
642:
643: -- +++++ Get Group's reserve retired +++++

Line 1929: from fa_asset_history

1925:
1926: /*
1927: select nvl(units,0)
1928: into h_cur_units
1929: from fa_asset_history
1930: where asset_id = h_asset_id
1931: and date_ineffective is null;
1932: */
1933: h_cur_units := 0;

Line 4800: from fa_asset_history

4796: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) Return BOOLEAN IS
4797:
4798: CURSOR c_get_unit is
4799: select units
4800: from fa_asset_history
4801: where asset_id = bk.group_asset_id
4802: and transaction_header_id_out is null;
4803:
4804: CURSOR c_get_cost is

Line 5305: from fa_asset_history

5301:
5302: /*
5303: select nvl(units,0)
5304: into h_cur_units
5305: from fa_asset_history
5306: where asset_id = h_asset_id
5307: and date_ineffective is null;
5308: */
5309: