APPS.FA_GAINLOSS_PKG dependencies on FA_RETIREMENTS

Line 46: SELECT /*+ ORDERED index ( RET FA_RETIREMENTS_N3 ) index( FAB FA_BOOKS_N5 ) use_nl ( RET FAB ) */

42: fail number;
43: -- bug# 4510549
44: -- Bug# 6937117
45: cursor c_assets is
46: SELECT /*+ ORDERED index ( RET FA_RETIREMENTS_N3 ) index( FAB FA_BOOKS_N5 ) use_nl ( RET FAB ) */
47: RET.RETIREMENT_ID
48: ,RET.ASSET_ID
49: ,FAA.ASSET_NUMBER
50: FROM FA_RETIREMENTS RET,

Line 50: FROM FA_RETIREMENTS RET,

46: SELECT /*+ ORDERED index ( RET FA_RETIREMENTS_N3 ) index( FAB FA_BOOKS_N5 ) use_nl ( RET FAB ) */
47: RET.RETIREMENT_ID
48: ,RET.ASSET_ID
49: ,FAA.ASSET_NUMBER
50: FROM FA_RETIREMENTS RET,
51: FA_BOOKS FAB,
52: FA_METHODS M,
53: FA_ADDITIONS_B FAA
54: WHERE RET.BOOK_TYPE_CODE = p_book_type_code

Line 424: fa_retirements table directly as a solution,

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

Line 437: from fa_retirements

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

Line 478: from fa_retirements

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

Line 718: from fa_retirements

714: l_event_type_code := 'RETIREMENTS';
715: else
716: select transaction_header_id_out
717: into l_thid
718: from fa_retirements
719: where retirement_id = l_asset_retire_rec.retirement_id;
720:
721: l_event_type_code := 'REINSTATEMENTS';
722: end if;