APPS.OZF_FORECAST_UTIL_PVT dependencies on OZF_TIME_DAY

Line 67: FROM ozf_time_day

63: --
64: x_record_type_id := 1;
65:
66: SELECT start_date, end_date INTO x_start_date, x_end_date
67: FROM ozf_time_day
68: WHERE report_date_julian = p_time_id;
69: --
70: END IF;
71: END get_dates;

Line 1493: FROM ozf_time_day

1489: 16, week_id,
1490: 32, month_id,
1491: 64, ent_qtr_id
1492: , ent_year_id ) time_id
1493: FROM ozf_time_day
1494: WHERE report_date BETWEEN p_start_date AND p_end_date;
1495:
1496: CURSOR day_csr(l_time_id IN NUMBER) IS
1497: SELECT to_char(report_date) name, start_date, end_date

Line 1498: FROM ozf_time_day

1494: WHERE report_date BETWEEN p_start_date AND p_end_date;
1495:
1496: CURSOR day_csr(l_time_id IN NUMBER) IS
1497: SELECT to_char(report_date) name, start_date, end_date
1498: FROM ozf_time_day
1499: WHERE report_date_julian = l_time_id;
1500:
1501: CURSOR week_csr(l_time_id IN NUMBER) IS
1502: SELECT name, start_date, end_date

Line 3330: ozf_time_day rpt,

3326: rpt.report_date
3327: ), 0)
3328: ) ,0) ) incremental_sales
3329: from OZF_BASEline_sales_v sales,
3330: ozf_time_day rpt,
3331: (select cust.qualifier_grouping_no,
3332: cust.cust_account_id,
3333: cust.site_use_code site_use_code,
3334: cust.site_use_id site_use_id,

Line 4003: ozf_time_day rpt,

3999: rpt.report_date
4000: ), 0)
4001: ) ,0) ) )incremental_sales
4002: from OZF_BASEline_sales_v sales,
4003: ozf_time_day rpt,
4004: (select cust.qualifier_grouping_no,
4005: cust.cust_account_id,
4006: cust.site_use_code site_use_code,
4007: cust.site_use_id site_use_id,