APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTF_QUAL_TYPE_USGS

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

1060: ,jqu.value3_id
1061: ,jqu.value4_id
1062: ,jqu.first_char
1063: FROM jtf_qual_usgs_all jqu
1064: ,jtf_qual_type_usgs jqtu
1065: ,jtf_qual_type_denorm_v v
1066: WHERE jqu.org_id = -3113
1067: AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id
1068: AND jqtu.source_id = lp_source_id

Line 1076: ,jtf_qual_type_usgs jqtu

1072: AND EXISTS ( SELECT jtq.terr_id
1073: FROM jtf_terr_qtype_usgs_all jtqu
1074: ,jtf_terr_all jt
1075: ,jtf_terr_qual_all jtq
1076: ,jtf_qual_type_usgs jqtu
1077: WHERE jt.end_date_active >= lp_start_date
1078: AND jt.start_date_active <= lp_end_date
1079: AND jtqu.terr_id = jt.terr_id
1080: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id

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

Line 1454: , jtf_qual_type_usgs jqtu

1450: SELECT COUNT(*)
1451: INTO l_num_of_terr
1452: FROM jtf_terr_qtype_usgs_all jtqu
1453: , jtf_terr_all jt1
1454: , jtf_qual_type_usgs jqtu
1455: WHERE jtqu.terr_id = jt1.terr_id
1456: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1457: AND jqtu.qual_type_id = p_trans_id
1458: AND jqtu.source_id = p_source_id

Line 1486: , jtf_qual_type_usgs jqtu

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