APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_RS_RESOURCES_VL

Line 378: SELECT EMAIL FROM jtf_rs_resources_vl

374: SELECT source_email
375: FROM jtf_rs_resource_extns
376: WHERE resource_id = p_resource_id;
377: CURSOR c_grp_email IS
378: SELECT EMAIL FROM jtf_rs_resources_vl
379: WHERE RESOURCE_ID = p_resource_id and resource_type = p_resource_type;
380:
381: l_email VARCHAR2(2000);
382: BEGIN