APPS.JL_ZZ_FA_REVAL_RULES_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 376: FROM fa_category_book_defaults a, fa_price_indexes b

372: END IF;
373:
374: SELECT price_index_id
375: INTO g_price_index
376: FROM fa_category_book_defaults a, fa_price_indexes b
377: WHERE a.book_type_code = p_book_type_code
378: AND a.category_id = p_category_id
379: AND p_date_placed_in_service >= a.start_dpis
380: AND p_date_placed_in_service <= NVL(a.end_dpis,p_date_placed_in_service)