1224: p_current_year_sales IN NUMBER ) AS
1225:
1226: CURSOR period_name_csr IS
1227: SELECT ent_period_id,
1228: ozf_time_api_pvt.get_period_name(ent_period_id, 32) period_name,
1229: ent_qtr_id,
1230: ozf_time_api_pvt.get_period_name(ent_qtr_id, 64) qtr_name,
1231: ent_year_id,
1232: ozf_time_api_pvt.get_period_name(ent_year_id, 128) year_name
1226: CURSOR period_name_csr IS
1227: SELECT ent_period_id,
1228: ozf_time_api_pvt.get_period_name(ent_period_id, 32) period_name,
1229: ent_qtr_id,
1230: ozf_time_api_pvt.get_period_name(ent_qtr_id, 64) qtr_name,
1231: ent_year_id,
1232: ozf_time_api_pvt.get_period_name(ent_year_id, 128) year_name
1233: FROM ozf_time_day
1234: WHERE report_date = p_report_date;
1228: ozf_time_api_pvt.get_period_name(ent_period_id, 32) period_name,
1229: ent_qtr_id,
1230: ozf_time_api_pvt.get_period_name(ent_qtr_id, 64) qtr_name,
1231: ent_year_id,
1232: ozf_time_api_pvt.get_period_name(ent_year_id, 128) year_name
1233: FROM ozf_time_day
1234: WHERE report_date = p_report_date;
1235:
1236: l_kpi_rec_count NUMBER;