DBA Data[Home] [Help]

APPS.OZF_QUOTA_PUB dependencies on OZF_TIME_ENT_YEAR

Line 198: SELECT start_date, end_date FROM OZF_TIME_ENT_YEAR

194: UNION ALL
195: SELECT start_date, end_date FROM OZF_TIME_ENT_QTR
196: WHERE name = p_period
197: UNION ALL
198: SELECT start_date, end_date FROM OZF_TIME_ENT_YEAR
199: WHERE name = p_period;
200:
201: CURSOR c_user_status_id (p_user_status_id IN NUMBER) IS
202: SELECT system_status_code

Line 998: SELECT 1 FROM OZF_TIME_ENT_YEAR

994: UNION
995: SELECT 1 FROM OZF_TIME_ENT_QTR
996: WHERE name = p_period
997: UNION
998: SELECT 1 FROM OZF_TIME_ENT_YEAR
999: WHERE name = p_period;
1000:
1001: CURSOR c_from_date (p_period IN VARCHAR2) IS
1002: SELECT start_date