DBA Data[Home] [Help]

APPS.FA_GAINLOSS_PKG dependencies on FA_METHODS

Line 48: FA_METHODS M

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
52: AND M.LIFE_IN_MONTHS(+) = RET.STL_LIFE_IN_MONTHS