APPS.JTY_MIGRATION_PVT dependencies on JTF_QUAL_USGS_ALL

Line 265: -- delete from jtf_qual_usgs_all where qual_type_usg_id

261: IS
262:
263: BEGIN
264:
265: -- delete from jtf_qual_usgs_all where qual_type_usg_id
266: -- in (select qual_type_usg_id
267: -- from jtf_qual_type_usgs_all
268: -- where qual_type_id = -1001);
269:

Line 562: -- intersection table for jtf_qual_usgs_all and

558: BEGIN
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

Line 583: , jtf_qual_usgs_all jqu

579: , jttu.terr_type_id
580: , jttu.org_id
581: from jtf_terr_type_usgs_all jttu
582: , jtf_qual_type_usgs_all jqtu
583: , jtf_qual_usgs_all jqu
584: where jttu.created_by = 2
585: and jqu.QUAL_TYPE_USG_ID = jqtu.qual_type_usg_id
586: and jqtu.source_id = jttu.source_id
587: and jttu.org_id = jqu.org_id

Line 645: delete from jtf_qual_usgs_all

641:
642: delete from jtf_seeded_qual_all_tl
643: where seeded_qual_id in (-1024, -1019);
644:
645: delete from jtf_qual_usgs_all
646: where qual_usg_id in (-1023,-1018);
647: end if;
648:
649: commit;