DBA Data[Home] [Help]

APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_RS_ROLES_B

Line 262: jtf_rs_roles_b jrrb

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(+)
266: AND jrrt.LANGUAGE = userenv('LANG');

Line 344: jtf_rs_roles_b jrrb

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;
348: