DBA Data[Home] [Help]

APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_RS_ROLES_B

Line 269: jtf_rs_roles_b jrrb

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

Line 351: jtf_rs_roles_b jrrb

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