APPS.OZF_QUOTA_PUB dependencies on OZF_TIME_ENT_PERIOD

Line 45: SELECT 1 FROM ozf_time_ent_period WHERE ent_period_id = p_time_id;

41: x_return_status OUT NOCOPY VARCHAR2)
42: IS
43:
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:

Line 192: SELECT start_date, end_date FROM OZF_TIME_ENT_PERIOD

188: AND activity_type_code = 'QUOTA'
189: AND custom_setup_id = p_custom_setup_id;
190:
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

Line 992: SELECT 1 FROM OZF_TIME_ENT_PERIOD

988: WHERE fund_type = 'QUOTA'
989: AND fund_number = p_quota_number;
990:
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