APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_RS_RESOURCES_VL
Line 4245: FROM jtf_rs_resources_vl jv
4241: /* cursor to get resource type name */
4242: CURSOR csr_get_rs_name ( lp_resource_id NUMBER
4243: , lp_resource_type VARCHAR2) IS
4244: SELECT jv.resource_name 4245: FROM jtf_rs_resources_vl jv 4246: WHERE jv.resource_id = lp_resource_id
4247: AND jv.resource_type = lp_resource_type
4248: AND rownum < 2;
4249: