APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_RS_ROLES_TL

Line 261: FROM jtf_rs_roles_tl jrrt,

257: AND LANGUAGE = userenv('LANG');
258:
259: CURSOR c_role_name IS
260: SELECT jrrt.role_name
261: FROM jtf_rs_roles_tl jrrt,
262: jtf_rs_roles_b jrrb
263: WHERE(p_role_id IS NULL OR jrrt.role_id = p_role_id)
264: AND jrrb.role_code(+) = p_role
265: AND jrrb.role_id = jrrt.role_id(+)

Line 343: FROM jtf_rs_roles_tl jrrt,

339: END get_group_name;
340:
341: FUNCTION get_role_name(p_resource_type VARCHAR, p_role VARCHAR2) RETURN VARCHAR IS CURSOR c_role_name IS
342: SELECT jrrt.role_name
343: FROM jtf_rs_roles_tl jrrt,
344: jtf_rs_roles_b jrrb
345: WHERE jrrt.role_id = jrrb.role_id
346: AND language = 'US'
347: AND jrrb.role_code = p_role;