DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 2643: from fa_distribution_history

2639: BEGIN
2640:
2641: select count(*)
2642: into l_count
2643: from fa_distribution_history
2644: where asset_id = p_asset_id
2645: -- and book_type_code = p_book
2646: and distribution_id = p_dist_id;
2647:

Line 2708: fa_distribution_history dh

2704: begin
2705: select count(*)
2706: into l_count1
2707: from fa_adjustments adj,
2708: fa_distribution_history dh
2709: where adj.asset_id = p_asset_id
2710: and adj.asset_id = dh.asset_id
2711: and adj.distribution_id = dh.distribution_id
2712: and dh.transaction_header_id_in = v_xfr_out_thid

Line 2723: fa_distribution_history dh

2719: begin
2720: select count(*)
2721: into l_count2
2722: from fa_deprn_detail dd,
2723: fa_distribution_history dh
2724: where dd.asset_id = p_asset_id
2725: and dd.asset_id = dh.asset_id
2726: and dd.distribution_id = dh.distribution_id
2727: and dh.transaction_header_id_in = v_xfr_out_thid;