DBA Data[Home] [Help]

APPS.OZF_TIME_PVT dependencies on OZF_TIME_ENT_QTR

Line 686: delete from OZF_TIME_ENT_QTR where start_date <= l_to_date and end_date >= l_from_date;

682: l_from_date := p_from_date;
683: l_to_date := p_to_date;
684: l_qtr_row := 0;
685:
686: delete from OZF_TIME_ENT_QTR where start_date <= l_to_date and end_date >= l_from_date;
687:
688: -- ----------------------
689: -- Populate Enterprise Quarter Level
690: -- ----------------------

Line 691: insert into OZF_TIME_ENT_QTR

687:
688: -- ----------------------
689: -- Populate Enterprise Quarter Level
690: -- ----------------------
691: insert into OZF_TIME_ENT_QTR
692: (ent_qtr_id,
693: ent_year_id,
694: sequence,
695: name,

Line 945: truncate_table('OZF_TIME_ENT_QTR');

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
949: OZF_TP_UTIL_PVT.put_line(' ');

Line 1255: from OZF_TIME_ENT_QTR

1251: sysdate,
1252: g_user_id,
1253: g_user_id,
1254: g_login_id
1255: from OZF_TIME_ENT_QTR
1256: where start_date >= c1_rec.ent_year_start_date
1257: and start_date <= c1_rec.ent_qtr_start_date
1258: and end_date < c1_rec.report_date
1259: union all

Line 1273: from OZF_TIME_ENT_QTR

1269: sysdate,
1270: g_user_id,
1271: g_user_id,
1272: g_login_id
1273: from OZF_TIME_ENT_QTR
1274: where start_date >= c1_rec.ent_year_start_date
1275: and start_date <= c1_rec.ent_qtr_start_date
1276: and end_date >= c1_rec.report_date;
1277: