APPS.FA_GAINLOSS_PKG dependencies on FA_RETIREMENTS

Line 46: FROM FA_RETIREMENTS RET,

42: -- bug# 4510549
43: cursor c_assets is
44: SELECT RET.RETIREMENT_ID,
45: RET.ASSET_ID
46: FROM FA_RETIREMENTS RET,
47: FA_BOOKS FAB,
48: FA_METHODS M
49: WHERE RET.BOOK_TYPE_CODE = p_book_type_code
50: AND RET.STATUS in ('PENDING', 'REINSTATE', 'PARTIAL')

Line 421: fa_retirements table directly as a solution,

417: The original solution provided through the fix on Bug 2937365
418: caused a problem described in Bug 3033462.
419: For full retirement transactions,
420: instead of nulling out units_retired column of
421: fa_retirements table directly as a solution,
422: we will null out ret.units_retired variable
423: to make sure that retirement routines process full retirement transactions
424: correctly.
425: (Null value of ret.units_retired is considered full retirement inside the code)

Line 434: from fa_retirements

430: into l_trx_type_code
431: from fa_transaction_headers
432: where transaction_header_id=
433: (select transaction_header_id_in
434: from fa_retirements
435: where retirement_id=p_retirement_id);
436:
437: exception
438: when others then

Line 475: from fa_retirements

471: -- Replace the following sql with a new component of retire struct
472: -- ret.date_effective := l_asset_retire_rec.detail_info.date_effective;
473: select date_effective
474: into ret.date_effective
475: from fa_retirements
476: where retirement_id = l_asset_retire_rec.retirement_id;
477:
478: ret.prorate_convention := l_asset_retire_rec.retirement_prorate_convention;
479:

Line 651: from fa_retirements_mrc_v

647: -- Replace the following sql with a new component of retire struct
648: -- ret.date_effective := lv_asset_retire_rec.detail_info.date_effective;
649: select date_effective
650: into ret.date_effective
651: from fa_retirements_mrc_v
652: where retirement_id = lv_asset_retire_rec.retirement_id;
653:
654: ret.prorate_convention := lv_asset_retire_rec.retirement_prorate_convention;
655: -- from reporting book

Line 725: from fa_retirements

721: l_event_type_code := 'RETIREMENTS';
722: else
723: select transaction_header_id_out
724: into l_thid
725: from fa_retirements
726: where retirement_id = l_asset_retire_rec.retirement_id;
727:
728: l_event_type_code := 'REINSTATEMENTS';
729: end if;