APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_RS_RESOURCES_VL

Line 371: SELECT EMAIL FROM jtf_rs_resources_vl

367: SELECT source_email
368: FROM jtf_rs_resource_extns
369: WHERE resource_id = p_resource_id;
370: CURSOR c_grp_email IS
371: SELECT EMAIL FROM jtf_rs_resources_vl
372: WHERE RESOURCE_ID = p_resource_id and resource_type = p_resource_type;
373:
374: l_email VARCHAR2(2000);
375: BEGIN