eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_MASS_RET_PKG dependencies on FA_DEPRN_PERIODS

Line 897: fa_deprn_periods dp

893: CURSOR check_current_period_add is
894: select 'FA_RET_CANT_RET_NONDEPRN'
895: from fa_transaction_headers th,
896: fa_book_controls bc,
897: fa_deprn_periods dp
898: where th.asset_id = p_Asset_id
899: AND th.book_type_code = G_Book_Type_Code
900: AND bc.book_type_code = th.book_type_code
901: AND th.transaction_type_code||''

Line 914: FA_DEPRN_PERIODS dp,

910: /* Excluded due to SLA
911: CURSOR check_current_period_cap is
912: select 'FA_RET_CANT_RET_NONDEPRN'
913: from FA_BOOKS fab,
914: FA_DEPRN_PERIODS dp,
915: FA_TRANSACTION_HEADERS th
916: where
917: fab.transaction_header_id_in = th.transaction_header_id
918: and fab.book_type_code = G_Book_Type_Code

Line 1026: fa_deprn_periods dp

1022:
1023: CURSOR check_asset_life_complete IS
1024: select 'EXTENDED LIFE'
1025: from fa_books bk,
1026: fa_deprn_periods dp
1027: where bk.asset_id = X_Asset_Id
1028: AND bk.book_type_code = G_Book_Type_Code
1029: AND nvl(period_Counter_fully_reserved,99) <> bk.period_counter_life_complete
1030: AND dp.book_type_code = bk.book_type_code