APPS.FARX_AL dependencies on FA_RETIREMENTS_MRC_V

Line 641: FROM FA_RETIREMENTS_mrc_v RET,

637: and th.transaction_header_id = ret.transaction_header_id_in
638: and th.transaction_type_code = 'FULL RETIREMENT';
639: else
640: SELECT count(*) INTO h_is_retired
641: FROM FA_RETIREMENTS_mrc_v RET,
642: fa_transaction_headers th
643: WHERE RET.ASSET_ID = h_asset_id
644: and ret.book_type_code = h_book
645: AND RET.DATE_EFFECTIVE <= ucd