DBA Data[Home] [Help]

APPS.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_PRICE_INDEX_VALUES

Line 1002: FROM fa_price_index_values

998:
999: BEGIN
1000: SELECT price_index_value
1001: INTO l_index_value_from
1002: FROM fa_price_index_values
1003: WHERE price_index_id = l_price_index
1004: AND l_reval_date BETWEEN from_date AND nvl(to_date,l_reval_date);
1005: EXCEPTION WHEN OTHERS THEN
1006: l_index_value_from := 0;

Line 1027: FROM fa_price_index_values

1023:
1024: BEGIN
1025: SELECT price_index_value
1026: INTO l_index_value_to
1027: FROM fa_price_index_values
1028: WHERE price_index_id = l_price_index
1029: AND l_reval_date BETWEEN from_date AND nvl(to_date,l_reval_date);
1030: EXCEPTION WHEN OTHERS THEN
1031: l_index_value_to := 0;