APPS.OZF_TIME_API_PVT dependencies on OZF_TIME_ENT_QTR

Line 38: FROM ozf_time_ent_qtr

34:
35: ELSIF p_period_type_id=64 THEN
36:
37: SELECT start_date INTO l_start_date
38: FROM ozf_time_ent_qtr
39: WHERE ent_qtr_id=p_time_id;
40:
41: ELSIF p_period_type_id=128 THEN
42:

Line 85: FROM ozf_time_ent_qtr

81:
82: ELSIF p_period_type_id=64 THEN
83:
84: SELECT end_date INTO l_end_date
85: FROM ozf_time_ent_qtr
86: WHERE ent_qtr_id=p_time_id;
87:
88: ELSIF p_period_type_id=128 THEN
89:

Line 133: FROM ozf_time_ent_qtr

129:
130: ELSIF p_period_type_id=64 THEN
131:
132: SELECT name INTO l_name
133: FROM ozf_time_ent_qtr
134: WHERE ent_qtr_id=p_time_id;
135:
136: ELSIF p_period_type_id=128 THEN
137:

Line 171: FROM ozf_time_ent_qtr

167:
168: ELSIF p_period_type_id=64 THEN
169:
170: SELECT name INTO l_name
171: FROM ozf_time_ent_qtr
172: WHERE ent_qtr_id=l_time_id;
173:
174: ELSIF p_period_type_id=128 THEN
175:

Line 215: FROM ozf_time_ent_qtr

211:
212: ELSIF p_period_type_id=64 THEN
213:
214: SELECT sequence, ent_year_id INTO l_curr_qtr, l_curr_year
215: FROM ozf_time_ent_qtr
216: WHERE ent_qtr_id=p_time_id;
217:
218: SELECT ent_qtr_id INTO l_time_id
219: FROM ozf_time_ent_qtr

Line 219: FROM ozf_time_ent_qtr

215: FROM ozf_time_ent_qtr
216: WHERE ent_qtr_id=p_time_id;
217:
218: SELECT ent_qtr_id INTO l_time_id
219: FROM ozf_time_ent_qtr
220: WHERE sequence=l_curr_qtr
221: AND ent_year_id=l_curr_year-1;
222:
223: ELSIF p_period_type_id=128 THEN

Line 257: FROM ozf_time_ent_qtr

253: Cursor get_qtr_ids_csr (l_start_date date,
254: l_end_date date) IS
255: SELECT
256: ent_qtr_id
257: FROM ozf_time_ent_qtr
258: WHERE start_date >= l_start_date
259: AND end_date <= l_end_date;
260:
261: Cursor get_month_ids_csr (l_start_date date,

Line 347: WHERE TRUNC(l_start_date) IN (SELECT DISTINCT START_DATE FROM OZF_TIME_ENT_QTR)

343: Cursor is_qtr_present_csr (l_start_date date,
344: l_end_date date) IS
345: SELECT 'Y'
346: FROM DUAL
347: WHERE TRUNC(l_start_date) IN (SELECT DISTINCT START_DATE FROM OZF_TIME_ENT_QTR)
348: AND TRUNC(l_end_date) IN (SELECT DISTINCT END_DATE FROM OZF_TIME_ENT_QTR);
349:
350: l_return_value CHAR := 'N';
351:

Line 348: AND TRUNC(l_end_date) IN (SELECT DISTINCT END_DATE FROM OZF_TIME_ENT_QTR);

344: l_end_date date) IS
345: SELECT 'Y'
346: FROM DUAL
347: WHERE TRUNC(l_start_date) IN (SELECT DISTINCT START_DATE FROM OZF_TIME_ENT_QTR)
348: AND TRUNC(l_end_date) IN (SELECT DISTINCT END_DATE FROM OZF_TIME_ENT_QTR);
349:
350: l_return_value CHAR := 'N';
351:
352: BEGIN