APPS.JTF_TERR_ENGINE_GEN2_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 433: , jtf_qual_type_usgs_all jqtu

429: UNION
430:
431: SELECT jqu.qual_usg_id, jqu.rule2
432: FROM jtf_qual_usgs_all jqu
433: , jtf_qual_type_usgs_all jqtu
434: , jtf_qual_type_denorm_v v
435: WHERE --jqu.enabled_flag = 'Y'
436: jqu.org_id = -3113
437: AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id

Line 948: Add_To_PackageTable (' ,jtf_qual_type_usgs_all jqa ');

944: Add_To_PackageTable (' jtw.terr_id ');
945: Add_To_PackageTable (' , jua.num_qual ' );
946: Add_To_PackageTable (' FROM jtf_terr_denorm_rules_all jtw ');
947: Add_To_PackageTable (' ,jtf_terr_qtype_usgs_all jua ');
948: Add_To_PackageTable (' ,jtf_qual_type_usgs_all jqa ');
949: Add_To_PackageTable (' WHERE jtw.source_id = lp_source_id');
950: Add_To_PackageTable (' AND jqa.source_id = jtw.source_id ');
951: Add_To_PackageTable (' AND jqa.qual_type_id = lp_qual_type_id ');
952: Add_To_PackageTable (' AND jtw.resource_exists_flag = ''Y'' ');