[Home] [Help]
134: SELECT
135: PRICE_INDEX_VALUE
136: INTO X
137: FROM
138: FA_PRICE_INDEX_VALUES
139: WHERE PRICE_INDEX_ID = C_PRICE_INDEX
140: AND ACQDATE BETWEEN FROM_DATE
141: AND TO_DATE;
142: RETURN (NVL(X
372: SELECT
373: PRICE_INDEX_VALUE
374: INTO INPC_HALF
375: FROM
376: FA_PRICE_INDEX_VALUES
377: WHERE PRICE_INDEX_ID = C_PRICE_INDEX
378: AND HALF_PERIOD_DATE BETWEEN FROM_DATE
379: AND TO_DATE;
380: RETURN (NVL(INPC_HALF