APPS.FA_RETIRE_PKG dependencies on FA_RETIREMENTS

Line 50: FROM FA_RETIREMENTS

46: end if;
47: -- check if another retirement/reinstatement already pending
48: SELECT count(*)
49: INTO LV_Count
50: FROM FA_RETIREMENTS
51: WHERE ASSET_ID = X_Asset_Id
52: AND BOOK_TYPE_CODE = X_Book_Type_Code
53: AND STATUS IN ('PENDING','REINSTATE');
54: --