APPS.FII_TIME_HOOK dependencies on EDW_TIME_EP_CAL_PERIOD_LSTG

Line 51: /* Check if data pushed from the master instance, if yes, table edw_time_ep_cal_period_lstg

47: select count(distinct instance) into instance_count
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:

Line 57: l_table:='edw_time_ep_cal_period_lstg';

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
57: l_table:='edw_time_ep_cal_period_lstg';
58: l_join:=' and ep.collection_status=''READY'' and ep.instance= '''||l_master_instance||'''';
59: select min(start_date), max(end_date)
60: into l_ep_min, l_ep_max
61: from edw_time_ep_cal_period_lstg;

Line 61: from edw_time_ep_cal_period_lstg;

57: l_table:='edw_time_ep_cal_period_lstg';
58: l_join:=' and ep.collection_status=''READY'' and ep.instance= '''||l_master_instance||'''';
59: select min(start_date), max(end_date)
60: into l_ep_min, l_ep_max
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';