eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BIL_BI_PURGE_OBJ_PKG dependencies on FII_TIME_ENT_PERIOD

Line 626: WHEN 'FII_TIME_ENT_PERIOD' THEN

622: DELETE bil_bi_fst_dtl_f sumry
623: WHERE forecast_time_id <= l_end_dt_ent_qtr_id
624: AND forecast_period_type_id = 64;
625:
626: WHEN 'FII_TIME_ENT_PERIOD' THEN
627:
628: SELECT ent_period_id
629: INTO l_end_dt_ent_per_id
630: FROM fii_time_ent_period

Line 630: FROM fii_time_ent_period

626: WHEN 'FII_TIME_ENT_PERIOD' THEN
627:
628: SELECT ent_period_id
629: INTO l_end_dt_ent_per_id
630: FROM fii_time_ent_period
631: WHERE start_date <= g_end_date
632: AND end_date >= g_end_date;
633:
634: DELETE bil_bi_fst_dtl_f sumry

Line 667: FROM fii_time_ent_period

663: AND end_date >= g_end_date;
664: -- Get the Time Dimension ID for the End Date (Period)
665: SELECT ent_period_id
666: INTO l_end_dt_ent_per_id
667: FROM fii_time_ent_period
668: WHERE start_date <= g_end_date
669: AND end_date >= g_end_date;
670: -- Get the Time Dimension ID for the End Date (Week)
671: SELECT week_id