APPS.FII_TIME_WH_API dependencies on EDW_TIME_M

Line 47: from edw_time_m

43: trunc(min(ecqr_start_date)),
44: trunc(max(ecqr_end_date)),
45: trunc(min(ecyr_start_date)),
46: trunc(max(ecyr_end_date))
47: from edw_time_m
48: where cday_calendar_date = trunc(sysdate);
49:
50: cursor c2 is
51: select trunc(min(ecqr_start_date)),

Line 55: from edw_time_m

51: select trunc(min(ecqr_start_date)),
52: trunc(max(ecqr_end_date)),
53: trunc(min(ecyr_start_date)),
54: trunc(max(ecyr_end_date))
55: from edw_time_m
56: where cday_calendar_date = add_months(trunc(sysdate), -12);
57:
58: cursor c3 is
59: select cal_qtr_pk_key

Line 63: from edw_time_m

59: select cal_qtr_pk_key
60: from edw_time_ep_cal_qtr_ltc
61: where start_date = (
62: select trunc(min(ecqr_start_date))
63: from edw_time_m
64: where cday_calendar_date = trunc(sysdate));
65:
66: cursor c4 is
67: select month_pk_key

Line 68: from edw_time_month_ltc

64: where cday_calendar_date = trunc(sysdate));
65:
66: cursor c4 is
67: select month_pk_key
68: from edw_time_month_ltc
69: where start_date = (select trunc(min(mnth_start_date))
70: from edw_time_m
71: where cday_calendar_date = trunc(sysdate));
72: begin

Line 70: from edw_time_m

66: cursor c4 is
67: select month_pk_key
68: from edw_time_month_ltc
69: where start_date = (select trunc(min(mnth_start_date))
70: from edw_time_m
71: where cday_calendar_date = trunc(sysdate));
72: begin
73:
74: init_set2;