APPS.BIL_BI_FST_DTL_F_PKG dependencies on FII_TIME_DAY

Line 2161: FII_TIME_Day fday

2157: 1,
2158: PRODUCT_CATEGORY_ID,
2159: CREDIT_TYPE_ID
2160: FROM BIL_BI_FST_DTL_STG stg,
2161: FII_TIME_Day fday
2162: WHERE stg.txn_day = fday.report_date_julian
2163: GROUP BY
2164: stg.FORECAST_PERIOD_DAY
2165: ,stg.FORECAST_PERIOD_WEEK

Line 2234: FII_TIME_Day fday

2230: 1,
2231: PRODUCT_CATEGORY_ID,
2232: CREDIT_TYPE_ID
2233: FROM BIL_BI_FST_DTL_STG stg,
2234: FII_TIME_Day fday
2235: WHERE stg.txn_day = fday.report_date_julian
2236: GROUP BY
2237: stg.FORECAST_PERIOD_DAY
2238: ,stg.FORECAST_PERIOD_WEEK

Line 3129: -- time records which does not exist in FII_TIME_DAY

3125:
3126:
3127: -----------------------------------------------------------
3128: -- If we find record in the aif table which references
3129: -- time records which does not exist in FII_TIME_DAY
3130: -- table, then we will exit the program with warning
3131: -- status
3132: -----------------------------------------------------------
3133: -- Check for Missing Time Dimension for Submission Date Time ID

Line 3264: fii_time_day fday

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
3268: AND ((exchange_rate < 0 OR exchange_rate IS NULL)