DBA Data[Home] [Help]

APPS.FA_MASS_RET_PKG dependencies on FA_RETIREMENTS

Line 873: from fa_retirements frt

869: -- Added this function for bug 586525.
870:
871: CURSOR check_pending_retirement is
872: select 'FA_SHARED_PENDING_RETIREMENT'
873: from fa_retirements frt
874: where frt.asset_id = p_Asset_Id
875: AND frt.book_type_code = G_Book_Type_Code
876: AND frt.status IN ('PENDING','REINSTATE');
877:

Line 880: from fa_retirements frt,

876: AND frt.status IN ('PENDING','REINSTATE');
877:
878: CURSOR check_processed_retirement is
879: select 'FA_REC_RETIRED'
880: from fa_retirements frt,
881: fa_books bk
882: where frt.asset_id = p_Asset_Id
883: AND bk.asset_id = frt.asset_id
884: AND bk.period_counter_fully_retired is NOT NULL