APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 1087: FROM jtf_terr_qtype_usgs_all jtqu

1083: AND jqtu.qual_type_id = v.related_id
1084: AND jqu.real_time_select IS NOT NULL
1085: AND v.qual_type_id = lp_trans_id
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

Line 1246: ' FROM jtf_terr_qtype_usgs_all jua ' ||

1242: 'HAVING (ILV.terr_id, COUNT(*)) IN ( ' ||
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 ' ||

Line 1485: FROM jtf_terr_qtype_usgs_all jtqu

1481: /* Check for the number of territories for this usage and transaction type */
1482: IF (p_mode = 'DATE EFFECTIVE' or p_mode = 'DEA INCREMENTAL') THEN
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

Line 1517: FROM jtf_terr_qtype_usgs_all jtqu

1513: AND rownum < 2;
1514: ELSE
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