[Home] [Help]
193: faadj.adjustment_amount,
194: faadj.track_member_flag --Bug8244128
195: FROM
196: fa_mc_adjustments faadj,
197: fa_mc_retirements faret,
198: fa_deprn_periods dp
199: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
200: AND faadj.asset_id = faret.asset_id
201: AND faadj.set_of_books_id = ret.set_of_books_id
224: faadj.adjustment_amount,
225: faadj.track_member_flag --Bug8244128
226: FROM
227: fa_mc_adjustments faadj,
228: fa_mc_retirements faret,
229: fa_deprn_periods dp
230: WHERE faadj.transaction_header_id = p_group_thid
231: AND faadj.asset_id = p_group_asset_id
232: AND faadj.book_type_Code = faret.book_type_code
271: last_update_date = today,
272: last_updated_by = user_id
273: WHERE retirement_id = ret.retirement_id;
274: else
275: UPDATE FA_MC_RETIREMENTS
276: SET status = 'DELETED',
277: last_update_date = today,
278: last_updated_by = user_id
279: WHERE retirement_id = ret.retirement_id
3719: * expense_amount -
3720: NVL(faadj.adjustment_amount, 0),
3721: (ABS(fadh.transaction_units) / faret.units)
3722: * expense_amount -- Bug 6666666
3723: FROM FA_MC_RETIREMENTS faret, fa_distribution_history fadh,
3724: fa_mc_adjustments faadj
3725: WHERE fadh.asset_id = RET.asset_id
3726: AND fadh.book_type_code = BK.dis_book
3727: AND fadh.retirement_id = RET.retirement_id
3763: faadj.distribution_id,
3764: faadj.code_combination_id,
3765: - 1 * faadj.adjustment_amount
3766: FROM
3767: FA_MC_RETIREMENTS faret,
3768: FA_DISTRIBUTION_HISTORY fadh,
3769: FA_MC_ADJUSTMENTS faadj
3770: WHERE fadh.asset_id(+) = RET.asset_id
3771: AND fadh.book_type_code(+) = BK.dis_book
4810: where retirement_id = ret.retirement_id;
4811: else
4812: select transaction_header_id_out
4813: into h_th_id_out
4814: from fa_mc_retirements
4815: where retirement_id = ret.retirement_id
4816: and set_of_books_id = ret.set_of_books_id;
4817: END IF;
4818: