APPS.JTY_MIGRATION_PVT dependencies on JTF_TERR_TYPES_ALL

Line 52: update jtf_terr_types_all

48: IS
49:
50: BEGIN
51:
52: update jtf_terr_types_all
53: set enabled_flag = 'Y'
54: where sysdate between start_date_active and nvl(end_date_active, sysdate);
55:
56: commit;

Line 311: from jtf_terr_types_all

307:
308: BEGIN
309: select 'Y'
310: into l_migration_complete
311: from jtf_terr_types_all
312: where substr(name,1,7) = 'General'
313: and created_by = 2
314: and rownum < 2;
315: EXCEPTION

Line 340: insert into jtf_terr_types_all

336: -- Insert territory types for all the usages
337: -- and org_id
338:
339: BEGIN
340: insert into jtf_terr_types_all
341: ( TERR_TYPE_ID
342: , LAST_UPDATED_BY
343: , LAST_UPDATE_DATE
344: , CREATED_BY

Line 390: insert into jtf_terr_types_all

386: BEGIN
387:
388: -- insert territory templates for
389: -- named accounts
390: insert into jtf_terr_types_all
391: ( TERR_TYPE_ID
392: , LAST_UPDATED_BY
393: , LAST_UPDATE_DATE
394: , CREATED_BY

Line 425: insert into jtf_terr_types_all

421: -- select -3113
422: -- from sys.dual);
423:
424:
425: insert into jtf_terr_types_all
426: ( TERR_TYPE_ID
427: , LAST_UPDATED_BY
428: , LAST_UPDATE_DATE
429: , CREATED_BY

Line 492: from jtf_terr_types_all

488: , sysdate
489: , terr_type_id
490: , ORIG_SYSTEM_REFERENCE_ID -- Used this column to temp store source_id
491: , org_id
492: from jtf_terr_types_all
493: where ORIG_SYSTEM_REFERENCE_ID is not null
494: and CREATED_BY = 2;
495:
496: EXCEPTION

Line 516: -- jtf_terr_types_all tables

512:
513: -- populate jtf_type_qtype_usgs_all table with
514: -- qual_type_usg_id and terr_type_id
515: -- intersection table for jtf_qual_type_usgs_all and
516: -- jtf_terr_types_all tables
517:
518: insert into jtf_type_qtype_usgs_all
519: ( TYPE_QTYPE_USG_ID
520: , LAST_UPDATED_BY

Line 563: -- jtf_terr_types_all tables

559:
560: -- populate jtf_terr_type_qual_all table with
561: -- QUAL_USG_ID and terr_type_id
562: -- intersection table for jtf_qual_usgs_all and
563: -- jtf_terr_types_all tables
564: insert into jtf_terr_type_qual_all
565: (TERR_TYPE_QUAL_ID
566: , LAST_UPDATED_BY
567: , LAST_UPDATE_DATE