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.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on FA_PRICE_INDEXES

Line 460: l_price_index fa_price_indexes.price_index_id%TYPE;

456: PROCEDURE get_index_rate(p_current_category IN VARCHAR2,
457: p_date_placed_in_service IN DATE,
458: p_adjustment_rate IN OUT NOCOPY NUMBER) IS
459:
460: l_price_index fa_price_indexes.price_index_id%TYPE;
461: l_current_index_value NUMBER := 0;
462: l_previous_index_value NUMBER:= 0;
463: l_api_name CONSTANT VARCHAR2(30) := 'GET_INDEX_RATE';
464:

Line 488: FROM fa_category_book_defaults a, fa_price_indexes b

484:
485:
486: SELECT b.price_index_id
487: INTO l_price_index
488: FROM fa_category_book_defaults a, fa_price_indexes b
489: WHERE a.book_type_code = p_book_type_code
490: AND a.category_id = p_current_category
491: AND p_date_placed_in_service >= a.start_dpis
492: AND p_date_placed_in_service <= NVL(a.end_dpis,p_date_placed_in_service)