APPS.OKL_CS_LC_CONTRACT_PVT dependencies on JTF_RS_ROLES_B

Line 1008: jtf_rs_roles_b rr

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)
1012: AND res.resource_id = rrr.role_resource_id

Line 1042: jtf_rs_roles_b rr,

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
1046: AND l_date BETWEEN NVL(rgb.start_date_active, l_date)

Line 1061: jtf_rs_roles_b rr,

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'
1065: AND rgd.group_id = rgm.group_id