DBA Data[Home] [Help]

APPS.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 974: FROM fa_category_book_defaults a, fa_price_indexes b

970:
971: BEGIN
972: SELECT price_index_id
973: INTO l_price_index
974: FROM fa_category_book_defaults a, fa_price_indexes b
975: WHERE a.book_type_code = p_adj_book_type_code
976: AND a.category_id = l_category_id
977: AND p_date_placed_in_service >= a.start_dpis
978: AND p_date_placed_in_service <= NVL(a.end_dpis,p_date_placed_in_service)