DBA Data[Home] [Help]

APPS.FA_GAINLOSS_PKG dependencies on FA_BOOKS

Line 47: FA_BOOKS FAB,

43: cursor c_assets is
44: SELECT RET.RETIREMENT_ID,
45: RET.ASSET_ID
46: FROM FA_RETIREMENTS RET,
47: FA_BOOKS FAB,
48: FA_METHODS M
49: WHERE RET.BOOK_TYPE_CODE = p_book_type_code
50: AND RET.STATUS in ('PENDING', 'REINSTATE', 'PARTIAL')
51: AND M.METHOD_CODE(+) = RET.STL_METHOD_CODE