APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_RS_ROLES_TL

Line 268: FROM jtf_rs_roles_tl jrrt,

264: AND LANGUAGE = userenv('LANG');
265:
266: CURSOR c_role_name IS
267: SELECT jrrt.role_name
268: FROM jtf_rs_roles_tl jrrt,
269: jtf_rs_roles_b jrrb
270: WHERE(p_role_id IS NULL OR jrrt.role_id = p_role_id)
271: AND jrrb.role_code(+) = p_role
272: AND jrrb.role_id = jrrt.role_id(+)

Line 350: FROM jtf_rs_roles_tl jrrt,

346: END get_group_name;
347:
348: FUNCTION get_role_name(p_resource_type VARCHAR, p_role VARCHAR2) RETURN VARCHAR IS CURSOR c_role_name IS
349: SELECT jrrt.role_name
350: FROM jtf_rs_roles_tl jrrt,
351: jtf_rs_roles_b jrrb
352: WHERE jrrt.role_id = jrrb.role_id
353: AND language = 'US'
354: AND jrrb.role_code = p_role;