APPS.JTY_MIGRATION_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 267: -- from jtf_qual_type_usgs_all

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:
270: delete from jtf_qual_type_usgs_all
271: where qual_type_id = -1001;

Line 270: delete from jtf_qual_type_usgs_all

266: -- in (select qual_type_usg_id
267: -- from jtf_qual_type_usgs_all
268: -- where qual_type_id = -1001);
269:
270: delete from jtf_qual_type_usgs_all
271: where qual_type_id = -1001;
272:
273: delete from jtf_qual_types_all
274: where qual_type_id = -1001;

Line 515: -- intersection table for jtf_qual_type_usgs_all and

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

Line 538: , jtf_qual_type_usgs_all jqtu

534: , jttu.terr_type_id
535: , jqtu.qual_type_usg_id
536: , jttu.org_id
537: from jtf_terr_type_usgs_all jttu
538: , jtf_qual_type_usgs_all jqtu
539: where jqtu.source_id = jttu.source_id
540: and jqtu.qual_type_usg_id <> -1005 -- Exclude service account transaction type
541: and jttu.created_by = 2;
542:

Line 582: , jtf_qual_type_usgs_all jqtu

578: , jqu.QUAL_USG_ID
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