DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 2852: from fa_distribution_history

2848: BEGIN
2849:
2850: select count(*)
2851: into l_count
2852: from fa_distribution_history
2853: where asset_id = p_asset_id
2854: and distribution_id = p_dist_id;
2855:
2856: if (l_count <> 0) then

Line 2914: fa_distribution_history dh

2910: begin
2911: select count(*)
2912: into l_count1
2913: from fa_adjustments adj,
2914: fa_distribution_history dh
2915: where adj.asset_id = p_asset_id
2916: and adj.asset_id = dh.asset_id
2917: and adj.distribution_id = dh.distribution_id
2918: and dh.transaction_header_id_in = v_xfr_out_thid

Line 2929: fa_distribution_history dh

2925: begin
2926: select count(*)
2927: into l_count2
2928: from fa_deprn_detail dd,
2929: fa_distribution_history dh
2930: where dd.asset_id = p_asset_id
2931: and dd.asset_id = dh.asset_id
2932: and dd.distribution_id = dh.distribution_id
2933: and dh.transaction_header_id_in = v_xfr_out_thid;

Line 6262: fa_distribution_history fdh

6258:
6259: CURSOR c_check_dist IS
6260: select count(1)
6261: from fa_deprn_detail fdd,
6262: fa_distribution_history fdh
6263: where fdd.distribution_id = fdh.distribution_id
6264: and fdd.book_type_code = p_book_type_code
6265: and fdd.asset_id = p_asset_Id
6266: and fdd.deprn_source_code = 'B'