DBA Data[Home] [Help]

APPS.OZF_TIME_API_PVT dependencies on OZF_TIME_WEEK

Line 26: FROM ozf_time_week

22:
23: ELSIF p_period_type_id=16 THEN
24:
25: SELECT start_date INTO l_start_date
26: FROM ozf_time_week
27: WHERE week_id=p_time_id;
28:
29: ELSIF p_period_type_id=32 THEN
30:

Line 73: FROM ozf_time_week

69:
70: ELSIF p_period_type_id=16 THEN
71:
72: SELECT end_date INTO l_end_date
73: FROM ozf_time_week
74: WHERE week_id=p_time_id;
75:
76: ELSIF p_period_type_id=32 THEN
77:

Line 121: FROM ozf_time_week

117:
118: ELSIF p_period_type_id=16 THEN
119:
120: SELECT name INTO l_name
121: FROM ozf_time_week
122: WHERE week_id=p_time_id;
123:
124: ELSIF p_period_type_id=32 THEN
125:

Line 273: FROM ozf_time_week

269: Cursor get_week_ids_csr (l_start_date date,
270: l_end_date date) IS
271: SELECT
272: week_id
273: FROM ozf_time_week
274: WHERE start_date >= l_start_date
275: AND end_date <= l_end_date;
276:
277: BEGIN