APPS.JTF_TTY_CREATE_TERR_FROM_GEO dependencies on DUAL

Line 155: FROM dual;

151: /*create the sequence only when call is from create otherwise use the existing ID */
152:
153: SELECT JTF_TERR_S.nextval
154: INTO l_terr_id
155: FROM dual;
156:
157: END IF;
158:
159:

Line 356: FROM DUAL;

352:
353: /* get the sequence */
354: SELECT JTF_TERR_QTYPE_USGS_S.NEXTVAL
355: INTO l_terr_qtype_usg_id
356: FROM DUAL;
357:
358: /* Insert into table jtf_terr_qtype_all */
359:
360: --dbms_output.put_line('insert into jtf_terr_qtype_usgs_all');

Line 413: FROM DUAL;

409:
410:
411: SELECT JTF_TERR_RSC_S.NEXTVAL
412: INTO l_terr_rsc_id
413: FROM DUAL;
414:
415: INSERT INTO jtf_terr_rsc_all
416: ( TERR_RSC_ID
417: ,LAST_UPDATE_DATE

Line 461: FROM DUAL;

457:
458: /* get the sequence */
459: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
460: INTO l_terr_rsc_access_id
461: FROM DUAL;
462:
463: /* commented this as all the types are found to be same
464: IF (rsc_acc.access_type= 'ACCOUNT') THEN
465: l_access_type :='ACCOUNT';