APPS.FII_TIME_HOOK dependencies on EDW_TIME_EP_CAL_PERIOD_LTC

Line 52: will be used to populate ep_cal_period_fk, if no, table edw_time_ep_cal_period_ltc will

48: from edw_time_cal_day_lstg
49: where ep_cal_period_fk = 'oracle_source' and collection_status='READY' and instance <> l_master_instance;
50:
51: /* Check if data pushed from the master instance, if yes, table edw_time_ep_cal_period_lstg
52: will be used to populate ep_cal_period_fk, if no, table edw_time_ep_cal_period_ltc will
53: be used instead. This is because the LSTG table may be purged before data is pushed from
54: another source. */
55:
56: if instance_count=0 then

Line 65: l_table:='edw_time_ep_cal_period_ltc';

61: from edw_time_ep_cal_period_lstg;
62: edw_log.put_line('Data is collected from the master instance, Enterprise Calendar in the staging table will be used to update the Calendar Day foreign keys.');
63: edw_log.put_line(' ');
64: else
65: l_table:='edw_time_ep_cal_period_ltc';
66: l_join:=null;
67: select min(start_date), max(end_date)
68: into l_ep_min, l_ep_max
69: from edw_time_ep_cal_period_ltc;

Line 69: from edw_time_ep_cal_period_ltc;

65: l_table:='edw_time_ep_cal_period_ltc';
66: l_join:=null;
67: select min(start_date), max(end_date)
68: into l_ep_min, l_ep_max
69: from edw_time_ep_cal_period_ltc;
70: edw_log.put_line('Data is not collected from the master instance, Enterprise Calendar in the level table will be used to update the Calendar Day foreign keys.');
71: edw_log.put_line(' ');
72: end if;
73: