APPS.FA_MASS_RET_PKG dependencies on FA_RETIREMENTS

Line 860: from fa_retirements frt

856: -- Added this function for bug 586525.
857:
858: CURSOR check_pending_retirement is
859: select 'FA_SHARED_PENDING_RETIREMENT'
860: from fa_retirements frt
861: where frt.asset_id = p_Asset_Id
862: AND frt.book_type_code = G_Book_Type_Code
863: AND frt.status IN ('PENDING','REINSTATE');
864:

Line 867: from fa_retirements frt,

863: AND frt.status IN ('PENDING','REINSTATE');
864:
865: CURSOR check_processed_retirement is
866: select 'FA_REC_RETIRED'
867: from fa_retirements frt,
868: fa_books bk
869: where frt.asset_id = p_Asset_Id
870: AND bk.asset_id = frt.asset_id
871: AND bk.period_counter_fully_retired is NOT NULL