DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_ADJUSTMENTS

Line 2913: from fa_adjustments adj,

2909:
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

Line 5791: , fa_adjustments aj

5787: cursor c_ret_adj_amount is
5788: select nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,-1*adjustment_amount)),0) ret_adj_amount
5789: from fa_transaction_headers th -- member
5790: , fa_transaction_headers gth -- group
5791: , fa_adjustments aj
5792: where th.book_type_code = p_asset_retire_rec.detail_info.book_type_code
5793: and th.source_transaction_header_id = gth.transaction_header_id
5794: and gth.book_type_code = p_asset_retire_rec.detail_info.book_type_code
5795: and gth.member_transaction_header_id = p_asset_retire_rec.detail_info.transaction_header_id_in