APPS.JTF_TERRITORY_GET_PUB dependencies on JTF_TERR_RESOURCES_V

Line 2802: l_from_clause := 'JTF_TERR_RESOURCES_V JTRV, ' || l_from_clause;

2798:
2799: gen_where_clause(l_dsql_csr, p_terr_rsc_rec, l_where_clause, l_use_terr_rsc_flag);
2800:
2801: IF ( l_use_terr_rsc_flag = 'Y' ) THEN
2802: l_from_clause := 'JTF_TERR_RESOURCES_V JTRV, ' || l_from_clause;
2803: l_where_clause := l_where_clause || ' AND JTRV.TERR_ID = JTOV.TERR_ID ';
2804: END IF;
2805:
2806:

Line 3329: FROM JTF_TERR_RESOURCES_V JTRV

3325: , JTRV.END_DATE_ACTIVE
3326: , JTRV.FULL_ACCESS_FLAG
3327: , JTRV.ORG_ID
3328: , JTRV.RESOURCE_NAME
3329: FROM JTF_TERR_RESOURCES_V JTRV
3330: WHERE terr_id = p_terr_id;
3331:
3332:
3333: /* Status local variable */