eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 969: jtf_rs_role_relations rrr,

965: -- considered
966: CURSOR res_csr IS
967: SELECT res.resource_id
968: FROM jtf_rs_resource_extns res,
969: jtf_rs_role_relations rrr,
970: jtf_rs_roles_b rr
971: WHERE res.user_id = Fnd_Global.user_id
972: AND l_date BETWEEN res.start_date_active
973: AND NVL(res.end_date_active, l_date)

Line 1003: jtf_rs_role_relations rrr,

999: -- subsequent contracts in the same session.
1000: CURSOR res_grp_csr IS
1001: SELECT rgm.group_id
1002: FROM jtf_rs_group_members rgm,
1003: jtf_rs_role_relations rrr,
1004: jtf_rs_roles_b rr,
1005: jtf_rs_groups_b rgb
1006: WHERE rgm.resource_id = g_user_resource_id
1007: AND rgm.group_id = rgb.group_id

Line 1022: jtf_rs_role_relations rrr,

1018: UNION
1019: SELECT rgd.parent_group_id
1020: FROM jtf_rs_group_members rgm,
1021: jtf_rs_groups_denorm rgd,
1022: jtf_rs_role_relations rrr,
1023: jtf_rs_roles_b rr,
1024: jtf_rs_groups_b rgb
1025: WHERE rgm.resource_id = g_user_resource_id
1026: AND NVL(rgm.delete_flag,'N') = 'N'