[Home] [Help]
142: SELECT
143: PRICE_INDEX_VALUE
144: INTO X
145: FROM
146: FA_PRICE_INDEX_VALUES
147: WHERE PRICE_INDEX_ID = C_PRICE_INDEX
148: AND JUNE_PERIOD_DATE BETWEEN FROM_DATE
149: AND TO_DATE;
150: RETURN (NVL(X
492: SELECT
493: PRICE_INDEX_VALUE
494: INTO X
495: FROM
496: FA_PRICE_INDEX_VALUES
497: WHERE PRICE_INDEX_ID = C_PRICE_INDEX
498: AND ACQDATE BETWEEN FROM_DATE
499: AND TO_DATE;
500: RETURN (NVL(X