APPS.OZF_TIME_PVT dependencies on OZF_TIME_ENT_PERIOD

Line 618: delete from OZF_TIME_ENT_PERIOD where start_date <= l_to_date and end_date >= l_from_date;

614: l_from_date := p_from_date;
615: l_to_date := p_to_date;
616: l_period_row := 0;
617:
618: delete from OZF_TIME_ENT_PERIOD where start_date <= l_to_date and end_date >= l_from_date;
619:
620: -- ----------------------
621: -- Populate Enterprise Period Level
622: -- ----------------------

Line 623: insert into OZF_TIME_ENT_PERIOD

619:
620: -- ----------------------
621: -- Populate Enterprise Period Level
622: -- ----------------------
623: insert into OZF_TIME_ENT_PERIOD
624: (ent_period_id,
625: ent_qtr_id,
626: ent_year_id,
627: sequence,

Line 760: from ozf_time_ent_period;

756: l_year_row := 0;
757:
758: select nvl(max(end_date), l_to_date)
759: into l_end_date
760: from ozf_time_ent_period;
761:
762: delete from OZF_TIME_ENT_YEAR where ent_year_id in
763: (select period_year
764: from gl_periods

Line 944: truncate_table('OZF_TIME_ENT_PERIOD');

940:
941:
942: else
943: truncate_table('OZF_TIME_WEEK');
944: truncate_table('OZF_TIME_ENT_PERIOD');
945: truncate_table('OZF_TIME_ENT_QTR');
946: truncate_table('OZF_TIME_ENT_YEAR');
947: truncate_table('OZF_TIME_RPT_STRUCT');
948: if g_debug_flag = 'Y' then

Line 1205: from OZF_TIME_ENT_PERIOD

1201: sysdate,
1202: g_user_id,
1203: g_user_id,
1204: g_login_id
1205: from OZF_TIME_ENT_PERIOD
1206: where start_date >= c1_rec.ent_qtr_start_date
1207: and start_date <= c1_rec.ent_period_start_date
1208: and end_date < c1_rec.report_date
1209: union all

Line 1223: from OZF_TIME_ENT_PERIOD

1219: sysdate,
1220: g_user_id,
1221: g_user_id,
1222: g_login_id
1223: from OZF_TIME_ENT_PERIOD
1224: where start_date >= c1_rec.ent_qtr_start_date
1225: and start_date <= c1_rec.ent_period_start_date
1226: and end_date >= c1_rec.report_date;
1227: