DBA Data[Home] [Help]

APPS.FA_TRANSFER_XIT_PKG dependencies on FA_MC_ADJUSTMENTS

Line 1976: from fa_mc_adjustments adj

1972: -adj.adjustment_amount)) adjustment_amount,
1973: sum(decode(adj.debit_credit_flag,'DR', adj.annualized_adjustment,
1974: -adj.annualized_adjustment)) annualized_adjustment,
1975: max(adj.track_member_flag) -- Bug7461343
1976: from fa_mc_adjustments adj
1977: ,fa_additions_b ad
1978: ,fa_distribution_history fad
1979: where adj.asset_id = p_asset_id
1980: and adj.book_type_code = p_book_type_code

Line 2218: delete from fa_mc_adjustments adj

2214: begin
2215:
2216: if (l_mrc_sob_type_code='R') then
2217:
2218: delete from fa_mc_adjustments adj
2219: where adj.asset_id = X_asset_id
2220: and adj.book_type_code = X_book_type_code
2221: and adj.period_counter_created = l_pc
2222: and adj.set_of_books_id = l_set_of_books_id

Line 2231: from fa_mc_adjustments adj1

2227: from fa_distribution_history dh
2228: where dh.transaction_header_id_out = X_th_id)
2229: and exists
2230: (select adj1.transaction_header_id
2231: from fa_mc_adjustments adj1
2232: where adj1.asset_id = X_asset_id
2233: and adj1.transaction_header_id = X_th_id
2234: and adj1.book_type_code = X_book_type_code
2235: and adj1.period_counter_created = l_pc