DBA Data[Home] [Help]

APPS.FII_CURR_CONV_MAINTAIN_PKG dependencies on FII_CURR_CONV_RATES_GT

Line 178: FROM FII_CURR_CONV_RATES_GT

174: , CONVERSION_TYPE
175: , CONVERSION_RATE
176: , CURRENCY_TYPE
177: , least(PERIOD_START_DATE, g_current_start_date) CONVERSION_DATE
178: FROM FII_CURR_CONV_RATES_GT
179: MINUS
180: SELECT
181: PERIOD_SET_NAME
182: , PERIOD_ID

Line 354: g_phase := 'Copy missing rates to FII_CURR_CONV_RATES_GT';

350: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT ||
351: ' rows into FII_CURR_CONV_RATES');
352: END IF;
353:
354: g_phase := 'Copy missing rates to FII_CURR_CONV_RATES_GT';
355:
356: insert into FII_CURR_CONV_RATES_GT (
357: PERIOD_SET_NAME
358: , PERIOD_ID

Line 356: insert into FII_CURR_CONV_RATES_GT (

352: END IF;
353:
354: g_phase := 'Copy missing rates to FII_CURR_CONV_RATES_GT';
355:
356: insert into FII_CURR_CONV_RATES_GT (
357: PERIOD_SET_NAME
358: , PERIOD_ID
359: , PERIOD_START_DATE
360: , PERIOD_END_DATE

Line 382: ' rows into FII_CURR_CONV_RATES_GT');

378: WHERE CONVERSION_RATE < 0;
379:
380: IF (FIIDIM_Debug) THEN
381: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT ||
382: ' rows into FII_CURR_CONV_RATES_GT');
383: END IF;
384:
385: g_phase := 'Update FII_CURR_CONV_RATES';
386: