DBA Data[Home] [Help]

APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_ASSET_HISTORY

Line 635: from fa_asset_history

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

Line 2138: from fa_asset_history

2134:
2135: /*
2136: select nvl(units,0)
2137: into h_cur_units
2138: from fa_asset_history
2139: where asset_id = h_asset_id
2140: and date_ineffective is null;
2141: */
2142:

Line 6312: from fa_asset_history

6308: p_log_level_rec in FA_API_TYPES.log_level_rec_type) Return BOOLEAN IS
6309:
6310: CURSOR c_get_unit is
6311: select units
6312: from fa_asset_history
6313: where asset_id = bk.group_asset_id
6314: and transaction_header_id_out is null;
6315:
6316: CURSOR c_get_cost is

Line 6991: from fa_asset_history

6987:
6988: /*
6989: select nvl(units,0)
6990: into h_cur_units
6991: from fa_asset_history
6992: where asset_id = h_asset_id
6993: and date_ineffective is null;
6994: */
6995: