DBA Data[Home] [Help]

APPS.JL_ZZ_FA_REVAL_RULES_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 378: FROM fa_category_book_defaults a, fa_price_indexes b

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