APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_RS_RESOURCES_VL
Line 4390: FROM jtf_rs_resources_vl jv
4386: /* cursor to get resource type name */
4387: CURSOR csr_get_rs_name ( lp_resource_id NUMBER
4388: , lp_resource_type VARCHAR2) IS
4389: SELECT jv.resource_name 4390: FROM jtf_rs_resources_vl jv 4391: WHERE jv.resource_id = lp_resource_id
4392: AND jv.resource_type = lp_resource_type
4393: AND rownum < 2;
4394: