DBA Data[Home] [Help]

APPS.OZF_TERR_LEVELS_PVT dependencies on DUAL

Line 208: FROM DUAL;

204: -- Cursor for getting the org_id
205:
206: CURSOR org_csr IS
207: SELECT NVL (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10), -99)
208: FROM DUAL;
209:
210: CURSOR c_get_seq IS
211: SELECT ozf_terr_levels_all_s.NEXTVAL
212: FROM DUAL;

Line 212: FROM DUAL;

208: FROM DUAL;
209:
210: CURSOR c_get_seq IS
211: SELECT ozf_terr_levels_all_s.NEXTVAL
212: FROM DUAL;
213:
214:
215: -- cursor to check uniqueness
216: CURSOR c_terr_id (l_terr_id IN NUMBER) IS