APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

Line 94: FROM jtf_qual_type_usgs_all

90: IF (p_qual_usg_id_tbl.COUNT > 0) THEN
91:
92: SELECT qual_type_usg_id
93: INTO l_qual_type_usg_id
94: FROM jtf_qual_type_usgs_all
95: WHERE source_id = p_source_id
96: AND qual_type_id = p_trans_id;
97:
98: FOR i IN p_qual_usg_id_tbl.FIRST .. p_qual_usg_id_tbl.LAST LOOP

Line 592: FROM jtf_qual_type_usgs_all

588: IF (p_qual_usg_id_tbl.COUNT > 0) THEN
589:
590: SELECT qual_type_usg_id
591: INTO l_qual_type_usg_id
592: FROM jtf_qual_type_usgs_all
593: WHERE source_id = p_source_id
594: AND qual_type_id = p_trans_id;
595:
596: FOR i IN p_qual_usg_id_tbl.FIRST .. p_qual_usg_id_tbl.LAST LOOP

Line 1247: ' ,jtf_qual_type_usgs_all jqa ' ||

1243: ' SELECT ' ||
1244: ' jua.terr_id ' ||
1245: ' ,jua.num_qual ' ||
1246: ' FROM jtf_terr_qtype_usgs_all jua ' ||
1247: ' ,jtf_qual_type_usgs_all jqa ' ||
1248: ' WHERE jqa.source_id = ' || p_source_id || ' ' ||
1249: ' AND jqa.qual_type_id = ' || p_trans_id || ' ' ||
1250: ' AND jua.qual_type_usg_id = jqa.qual_type_usg_id ' ||
1251: ' AND jua.terr_id = ilv.terr_id ) ';