APPS.OZF_TIME_API_PVT dependencies on OZF_TIME_ENT_PERIOD

Line 32: FROM ozf_time_ent_period

28:
29: ELSIF p_period_type_id=32 THEN
30:
31: SELECT start_date INTO l_start_date
32: FROM ozf_time_ent_period
33: WHERE ent_period_id=p_time_id;
34:
35: ELSIF p_period_type_id=64 THEN
36:

Line 79: FROM ozf_time_ent_period

75:
76: ELSIF p_period_type_id=32 THEN
77:
78: SELECT end_date INTO l_end_date
79: FROM ozf_time_ent_period
80: WHERE ent_period_id=p_time_id;
81:
82: ELSIF p_period_type_id=64 THEN
83:

Line 127: FROM ozf_time_ent_period

123:
124: ELSIF p_period_type_id=32 THEN
125:
126: SELECT name INTO l_name
127: FROM ozf_time_ent_period
128: WHERE ent_period_id=p_time_id;
129:
130: ELSIF p_period_type_id=64 THEN
131:

Line 165: FROM ozf_time_ent_period

161:
162: ELSIF p_period_type_id=32 THEN
163:
164: SELECT name INTO l_name
165: FROM ozf_time_ent_period
166: WHERE ent_period_id=l_time_id;
167:
168: ELSIF p_period_type_id=64 THEN
169:

Line 204: FROM ozf_time_ent_period

200:
201: ELSIF p_period_type_id=32 THEN
202:
203: SELECT sequence, ent_year_id INTO l_curr_period, l_curr_year
204: FROM ozf_time_ent_period
205: WHERE ent_period_id=p_time_id;
206:
207: SELECT ent_period_id INTO l_time_id
208: FROM ozf_time_ent_period

Line 208: FROM ozf_time_ent_period

204: FROM ozf_time_ent_period
205: WHERE ent_period_id=p_time_id;
206:
207: SELECT ent_period_id INTO l_time_id
208: FROM ozf_time_ent_period
209: WHERE sequence=l_curr_period
210: AND ent_year_id=l_curr_year-1;
211:
212: ELSIF p_period_type_id=64 THEN

Line 265: FROM ozf_time_ent_period

261: Cursor get_month_ids_csr (l_start_date date,
262: l_end_date date) IS
263: SELECT
264: ent_period_id
265: FROM ozf_time_ent_period
266: WHERE start_date >= l_start_date
267: AND end_date <= l_end_date;
268:
269: Cursor get_week_ids_csr (l_start_date date,

Line 385: FROM OZF_TIME_ENT_PERIOD

381:
382: Cursor no_of_periods_csr (l_start_date date,
383: l_end_date date) IS
384: SELECT COUNT(ent_period_id)
385: FROM OZF_TIME_ENT_PERIOD
386: WHERE START_DATE >= TRUNC(p_start_date)
387: AND END_DATE <= TRUNC(p_end_date);
388:
389: l_return_value NUMBER := 13;