APPS.CSR_RULES_PVT dependencies on JTF_TERR_ALL

Line 286: FROM jtf_terr_all t, csr_rules_b r

282:
283: FUNCTION get_parent_territory_rule(p_terr_id NUMBER, p_rule_doc XMLTYPE) RETURN NUMBER IS
284: CURSOR c_terr_hier IS
285: SELECT DISTINCT t.terr_id, LEVEL terr_level, r.rule_id
286: FROM jtf_terr_all t, csr_rules_b r
287: WHERE t.terr_id = r.terr_id (+)
288: AND NVL(r.rule_rank, 16) = 16
289: START WITH t.terr_id = p_terr_id
290: CONNECT BY NOCYCLE PRIOR t.parent_territory_id = t.terr_id

Line 1355: FROM jtf_terr_all

1351: SELECT extractValue(r.rule_doc, v_param_path)
1352: FROM csr_rules_b r
1353: , (
1354: SELECT terr_id, LEVEL terr_level
1355: FROM jtf_terr_all
1356: START WITH terr_id = p_terr_id
1357: CONNECT BY NOCYCLE PRIOR parent_territory_id = terr_id
1358: ) t
1359: WHERE r.appl_id IN (p_appl_id, g_not_specified)

Line 1454: , (SELECT terr_id, LEVEL terr_level FROM jtf_terr_all

1450:
1451: l_rules_with_terr_query CONSTANT VARCHAR2(1000) :=
1452: 'SELECT r.*
1453: FROM csr_rules_vl r
1454: , (SELECT terr_id, LEVEL terr_level FROM jtf_terr_all
1455: START WITH terr_id = :terr_id
1456: CONNECT BY NOCYCLE PRIOR parent_territory_id = terr_id
1457: UNION ALL SELECT -9999, 9999999 FROM DUAL
1458: ) t