APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 1073: FROM jtf_terr_qtype_usgs_all jtqu

1069: AND jqtu.qual_type_id = v.related_id
1070: AND jqu.real_time_select IS NOT NULL
1071: AND v.qual_type_id = lp_trans_id
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

Line 1238: ' FROM jtf_terr_qtype_usgs_all jua ' ||

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

Line 1452: FROM jtf_terr_qtype_usgs_all jtqu

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

Line 1484: FROM jtf_terr_qtype_usgs_all jtqu

1480: AND rownum < 2;
1481: ELSE
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