APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 277: FROM jtf_rs_resource_extns_tl

273: AND jrrt.LANGUAGE = userenv('LANG');
274:
275: CURSOR c_resource_name IS
276: SELECT resource_name
277: FROM jtf_rs_resource_extns_tl
278: WHERE resource_id = p_resource_id
279: AND LANGUAGE = userenv('LANG');
280: l_name VARCHAR2(250) := NULL;
281: BEGIN

Line 375: FROM jtf_rs_resource_extns

371:
372: FUNCTION get_email(p_resource_type VARCHAR, p_resource_id NUMBER) RETURN VARCHAR IS
373: CURSOR c_email IS
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;