APPS.JTF_TTY_CREATE_TERR_FROM_GEO dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 141: DELETE FROM jtf_terr_qtype_usgs_all where terr_id = l_terr_id;

137: IF l_terr_id IS NOT NULL THEN
138: /* Update case All the delete scripts here */
139:
140: DELETE FROM jtf_terr_usgs_all where terr_id = l_terr_id;
141: DELETE FROM jtf_terr_qtype_usgs_all where terr_id = l_terr_id;
142:
143: DELETE FROM jtf_terr_rsc_access_all
144: WHERE terr_rsc_id IN (SELECT terr_rsc_id FROM jtf_terr_rsc_all WHERE terr_id = l_terr_id);
145:

Line 360: --dbms_output.put_line('insert into jtf_terr_qtype_usgs_all');

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');
361: INSERT INTO jtf_terr_qtype_usgs_all
362: (TERR_QTYPE_USG_ID
363: , LAST_UPDATED_BY
364: , LAST_UPDATE_DATE

Line 361: INSERT INTO jtf_terr_qtype_usgs_all

357:
358: /* Insert into table jtf_terr_qtype_all */
359:
360: --dbms_output.put_line('insert into jtf_terr_qtype_usgs_all');
361: INSERT INTO jtf_terr_qtype_usgs_all
362: (TERR_QTYPE_USG_ID
363: , LAST_UPDATED_BY
364: , LAST_UPDATE_DATE
365: , CREATED_BY

Line 384: --dbms_output.put_line(' After inserting jtf_terr_qtype_usgs_all');

380: , l_org_id
381: FROM jtf_tty_geo_terr
382: WHERE geo_territory_id = p_geo_terr_id;
383:
384: --dbms_output.put_line(' After inserting jtf_terr_qtype_usgs_all');
385:
386:
387:
388: