DBA Data[Home] [Help]

APPS.OZF_TIME_API_PVT dependencies on OZF_TIME_ENT_YEAR

Line 44: FROM ozf_time_ent_year

40:
41: ELSIF p_period_type_id=128 THEN
42:
43: SELECT start_date INTO l_start_date
44: FROM ozf_time_ent_year
45: WHERE ent_year_id=p_time_id;
46:
47: END IF;
48:

Line 91: FROM ozf_time_ent_year

87:
88: ELSIF p_period_type_id=128 THEN
89:
90: SELECT end_date INTO l_end_date
91: FROM ozf_time_ent_year
92: WHERE ent_year_id=p_time_id;
93:
94: END IF;
95:

Line 139: FROM ozf_time_ent_year

135:
136: ELSIF p_period_type_id=128 THEN
137:
138: SELECT name INTO l_name
139: FROM ozf_time_ent_year
140: WHERE ent_year_id=p_time_id;
141:
142: END IF;
143:

Line 177: FROM ozf_time_ent_year

173:
174: ELSIF p_period_type_id=128 THEN
175:
176: SELECT name INTO l_name
177: FROM ozf_time_ent_year
178: WHERE ent_year_id=l_time_id;
179:
180: END IF;
181:

Line 249: FROM ozf_time_ent_year

245: Cursor get_year_ids_csr (l_start_date date,
246: l_end_date date) IS
247: SELECT
248: ent_year_id
249: FROM ozf_time_ent_year
250: WHERE start_date >= l_start_date
251: AND end_date <= l_end_date;
252:
253: Cursor get_qtr_ids_csr (l_start_date date,