APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 84: FROM jtf_qual_type_usgs_all

80: IF (p_qual_usg_id_tbl.COUNT > 0) THEN
81:
82: SELECT qual_type_usg_id
83: INTO l_qual_type_usg_id
84: FROM jtf_qual_type_usgs_all
85: WHERE source_id = p_source_id
86: AND qual_type_id = p_trans_id;
87:
88: FOR i IN p_qual_usg_id_tbl.FIRST .. p_qual_usg_id_tbl.LAST LOOP

Line 586: FROM jtf_qual_type_usgs_all

582: IF (p_qual_usg_id_tbl.COUNT > 0) THEN
583:
584: SELECT qual_type_usg_id
585: INTO l_qual_type_usg_id
586: FROM jtf_qual_type_usgs_all
587: WHERE source_id = p_source_id
588: AND qual_type_id = p_trans_id;
589:
590: FOR i IN p_qual_usg_id_tbl.FIRST .. p_qual_usg_id_tbl.LAST LOOP

Line 1239: ' ,jtf_qual_type_usgs_all jqa ' ||

1235: ' SELECT ' ||
1236: ' jua.terr_id ' ||
1237: ' ,jua.num_qual ' ||
1238: ' FROM jtf_terr_qtype_usgs_all jua ' ||
1239: ' ,jtf_qual_type_usgs_all jqa ' ||
1240: ' WHERE jqa.source_id = ' || p_source_id || ' ' ||
1241: ' AND jqa.qual_type_id = ' || p_trans_id || ' ' ||
1242: ' AND jua.qual_type_usg_id = jqa.qual_type_usg_id ' ||
1243: ' AND jua.terr_id = ilv.terr_id ) ';