APPS.OZF_THRESHOLD_RULE_PVT dependencies on DUAL

Line 150: FROM dual;

146: l_return_status VARCHAR2(30);
147:
148: CURSOR c_id IS
149: SELECT OZF_THRESHOLD_RULES_s.NEXTVAL
150: FROM dual;
151:
152: CURSOR c_id_exists (l_id IN NUMBER) IS
153: SELECT 1 FROM dual
154: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLD_RULES_ALL

Line 153: SELECT 1 FROM dual

149: SELECT OZF_THRESHOLD_RULES_s.NEXTVAL
150: FROM dual;
151:
152: CURSOR c_id_exists (l_id IN NUMBER) IS
153: SELECT 1 FROM dual
154: WHERE EXISTS (SELECT 1 FROM OZF_THRESHOLD_RULES_ALL
155: WHERE THRESHOLD_RULE_ID = l_id);
156:
157: BEGIN