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 1007: jtf_rs_role_relations rrr,

1003: -- considered
1004: CURSOR res_csr IS
1005: SELECT res.resource_id
1006: FROM jtf_rs_resource_extns res,
1007: jtf_rs_role_relations rrr,
1008: jtf_rs_roles_b rr
1009: WHERE res.user_id = Fnd_Global.user_id
1010: AND l_date BETWEEN res.start_date_active
1011: AND NVL(res.end_date_active, l_date)

Line 1041: jtf_rs_role_relations rrr,

1037: -- subsequent contracts in the same session.
1038: CURSOR res_grp_csr IS
1039: SELECT rgm.group_id
1040: FROM jtf_rs_group_members rgm,
1041: jtf_rs_role_relations rrr,
1042: jtf_rs_roles_b rr,
1043: jtf_rs_groups_b rgb
1044: WHERE rgm.resource_id = g_user_resource_id
1045: AND rgm.group_id = rgb.group_id

Line 1060: jtf_rs_role_relations rrr,

1056: UNION
1057: SELECT rgd.parent_group_id
1058: FROM jtf_rs_group_members rgm,
1059: jtf_rs_groups_denorm rgd,
1060: jtf_rs_role_relations rrr,
1061: jtf_rs_roles_b rr,
1062: jtf_rs_groups_b rgb
1063: WHERE rgm.resource_id = g_user_resource_id
1064: AND NVL(rgm.delete_flag,'N') = 'N'