DBA Data[Home] [Help]

APPS.OZF_FUNDTHRESHOLD_PVT dependencies on DUAL

Line 47: FROM dual

43:
44: CURSOR c_threshold_calendar
45: IS
46: SELECT 1
47: FROM dual
48: WHERE EXISTS(SELECT 1
49: FROM gl_periods_v
50: WHERE period_set_name = p_threshold_calendar);
51:

Line 195: FROM dual;

191: l_return_status VARCHAR2(30);
192:
193: CURSOR c_id IS
194: SELECT OZF_THRESHOLDS_s.NEXTVAL
195: FROM dual;
196:
197: CURSOR c_id_exists (l_id IN NUMBER) IS
198: SELECT 1 FROM dual
199: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLDS_ALL_B

Line 198: SELECT 1 FROM dual

194: SELECT OZF_THRESHOLDS_s.NEXTVAL
195: FROM dual;
196:
197: CURSOR c_id_exists (l_id IN NUMBER) IS
198: SELECT 1 FROM dual
199: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLDS_ALL_B
200: WHERE THRESHOLD_ID = l_id);
201:
202: BEGIN