APPS.OZF_QUOTA_PUB dependencies on OZF_TIME_ENT_QTR

Line 48: SELECT 1 FROM ozf_time_ent_qtr WHERE ent_qtr_id = p_time_id;

44: CURSOR c_chk_period(p_time_id IN NUMBER) IS
45: SELECT 1 FROM ozf_time_ent_period WHERE ent_period_id = p_time_id;
46:
47: CURSOR c_chk_qtr(p_time_id IN NUMBER) IS
48: SELECT 1 FROM ozf_time_ent_qtr WHERE ent_qtr_id = p_time_id;
49:
50: l_time_id NUMBER;
51:
52: BEGIN

Line 195: SELECT start_date, end_date FROM OZF_TIME_ENT_QTR

191: CURSOR c_period_exists (p_period IN VARCHAR2) IS
192: SELECT start_date, end_date FROM OZF_TIME_ENT_PERIOD
193: WHERE name = p_period
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;

Line 995: SELECT 1 FROM OZF_TIME_ENT_QTR

991: CURSOR c_period_exists (p_period IN VARCHAR2) IS
992: SELECT 1 FROM OZF_TIME_ENT_PERIOD
993: WHERE name = p_period
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;