APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTF_QUAL_TYPE_USGS

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 1078: ,jtf_qual_type_usgs jqtu

1074: ,jqu.value3_id
1075: ,jqu.value4_id
1076: ,jqu.first_char
1077: FROM jtf_qual_usgs_all jqu
1078: ,jtf_qual_type_usgs jqtu
1079: ,jtf_qual_type_denorm_v v
1080: WHERE jqu.org_id = -3113
1081: AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id
1082: AND jqtu.source_id = lp_source_id

Line 1090: ,jtf_qual_type_usgs jqtu

1086: AND EXISTS ( SELECT jtq.terr_id
1087: FROM jtf_terr_qtype_usgs_all jtqu
1088: ,jtf_terr_all jt
1089: ,jtf_terr_qual_all jtq
1090: ,jtf_qual_type_usgs jqtu
1091: WHERE jt.end_date_active >= lp_start_date
1092: AND jt.start_date_active <= lp_end_date
1093: AND jtqu.terr_id = jt.terr_id
1094: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id

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 ) ';

Line 1487: , jtf_qual_type_usgs jqtu

1483: SELECT COUNT (jt1.terr_id)
1484: INTO l_num_of_terr
1485: FROM jtf_terr_qtype_usgs_all jtqu
1486: , jtf_terr_all jt1
1487: , jtf_qual_type_usgs jqtu
1488: WHERE jtqu.terr_id = jt1.terr_id
1489: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1490: AND jqtu.qual_type_id = p_trans_id
1491: AND jqtu.source_id = p_source_id

Line 1519: , jtf_qual_type_usgs jqtu

1515: SELECT COUNT(jt1.terr_id)
1516: INTO l_num_of_terr
1517: FROM jtf_terr_qtype_usgs_all jtqu
1518: , jtf_terr_all jt1
1519: , jtf_qual_type_usgs jqtu
1520: WHERE jtqu.terr_id = jt1.terr_id
1521: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1522: AND jqtu.qual_type_id = p_trans_id
1523: AND jqtu.source_id = p_source_id