APPS.BIL_BI_FST_DTL_F_PKG dependencies on BIL_BI_CURRENCY_RATE

Line 1355: MERGE INTO BIL_BI_CURRENCY_RATE sumry

1351: p_msg => 'Start of Procedure '|| l_proc);
1352: END IF;
1353:
1354:
1355: MERGE INTO BIL_BI_CURRENCY_RATE sumry
1356: USING
1357: (
1358: SELECT
1359: currency_code,

Line 1403: p_msg => 'Merged '||sql%rowcount||' into bil_bi_currency_rate table');

1399: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
1400: bil_bi_util_collection_pkg.writeLog(
1401: p_log_level => fnd_log.LEVEL_EVENT,
1402: p_module => g_pkg || l_proc ,
1403: p_msg => 'Merged '||sql%rowcount||' into bil_bi_currency_rate table');
1404: END IF;
1405:
1406: --update bil.bil_bi_currency_rate set exchange_rate = -1,exchange_rate_s = -1 where rownum < 2;
1407:

Line 1406: --update bil.bil_bi_currency_rate set exchange_rate = -1,exchange_rate_s = -1 where rownum < 2;

1402: p_module => g_pkg || l_proc ,
1403: p_msg => 'Merged '||sql%rowcount||' into bil_bi_currency_rate table');
1404: END IF;
1405:
1406: --update bil.bil_bi_currency_rate set exchange_rate = -1,exchange_rate_s = -1 where rownum < 2;
1407:
1408: COMMIT;
1409:
1410: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

Line 1612: bil_bi_currency_rate rates

1608: FROM
1609: as_internal_forecasts aif,
1610: bil_bi_new_fst_id bnfi,
1611: as_fst_sales_categories asfc,
1612: bil_bi_currency_rate rates
1613: WHERE
1614: aif.forecast_id = bnfi.forecast_id
1615: AND aif.status_code = 'SUBMITTED'
1616: AND aif.submission_date >= g_start_date

Line 1662: bil_bi_currency_rate rates

1658: FROM
1659: as_internal_forecasts aif,
1660: as_prod_worksheet_lines apwsl,
1661: bil_bi_new_fst_id bnfi,
1662: bil_bi_currency_rate rates
1663: WHERE
1664: aif.forecast_id = bnfi.forecast_id
1665: AND aif.status_code = 'SUBMITTED'
1666: AND apwsl.status_code = 'SUBMITTED'

Line 1787: bil_bi_currency_rate rates

1783: FROM
1784: as_internal_forecasts aif,
1785: as_prod_worksheet_lines apwsl,
1786: bil_bi_new_fst_id bnfi,
1787: bil_bi_currency_rate rates
1788: WHERE
1789: aif.forecast_id = bnfi.forecast_id
1790: AND aif.status_code = 'SUBMITTED'
1791: AND apwsl.status_code = 'SUBMITTED'

Line 3074: FROM bil_bi_currency_rate rates

3070: IF (g_truncate_flag OR g_first_run) THEN
3071:
3072: SELECT /*+ PARALLEL(rates) */ COUNT(1)
3073: INTO g_conv_rate_cnt
3074: FROM bil_bi_currency_rate rates
3075: WHERE ((exchange_rate < 0 OR exchange_rate is NULL)
3076: OR (g_sec_currency IS NOT NULL AND (exchange_rate_s < 0 OR exchange_rate_s is NULL)))
3077: AND exchange_date IN (SELECT DISTINCT TRUNC(submission_date) FROM bil_bi_new_fst_id)
3078: AND rownum < 2;

Line 3082: FROM bil_bi_currency_rate

3078: AND rownum < 2;
3079: ELSE
3080: SELECT COUNT(1)
3081: INTO g_conv_rate_cnt
3082: FROM bil_bi_currency_rate
3083: WHERE ((exchange_rate < 0 OR exchange_rate is NULL)
3084: OR (g_sec_currency IS NOT NULL AND (exchange_rate_s < 0 OR exchange_rate_s is NULL)))
3085: AND exchange_date IN (SELECT DISTINCT TRUNC(submission_date) FROM bil_bi_new_fst_id)
3086: AND rownum < 2;

Line 3263: bil_bi_currency_rate rate,

3259: TO_DATE('01/01/1999','MM/DD/RRRR'), LEAST(SYSDATE,report_date))) report_date,
3260: decode(sign(nvl(rate.exchange_rate,-1)),-1,'P') prim_curr_type,
3261: decode(sign(nvl(rate.exchange_rate_s,-1)),-1,'S') sec_curr_type
3262: FROM
3263: bil_bi_currency_rate rate,
3264: fii_time_day fday
3265: WHERE
3266: rate.exchange_date IN (SELECT DISTINCT TRUNC(submission_date) FROM bil_bi_new_fst_id)
3267: AND rate.exchange_date = fday.report_date