APPS.OKC_UTIL dependencies on JTF_RS_ROLES_B

Line 1683: jtf_rs_roles_b rr

1679: CURSOR res_csr IS
1680: SELECT res.resource_id
1681: FROM jtf_rs_resource_extns res,
1682: jtf_rs_role_relations rrr,
1683: jtf_rs_roles_b rr
1684: WHERE res.user_id = fnd_global.user_id
1685: AND l_date between res.start_date_active
1686: and nvl(res.end_date_active, l_date)
1687: AND res.resource_id = rrr.role_resource_id

Line 1723: jtf_rs_roles_b rr,

1719: CURSOR res_grp_csr is
1720: SELECT rgm.group_id
1721: FROM jtf_rs_group_members rgm,
1722: jtf_rs_role_relations rrr,
1723: jtf_rs_roles_b rr,
1724: jtf_rs_groups_b rgb
1725: WHERE rgm.resource_id = g_user_resource_id
1726: AND rgm.group_id = rgb.group_id
1727: AND l_date between nvl(rgb.start_date_active, l_date)

Line 1742: jtf_rs_roles_b rr,

1738: SELECT rgd.parent_group_id
1739: FROM jtf_rs_group_members rgm,
1740: jtf_rs_groups_denorm rgd,
1741: jtf_rs_role_relations rrr,
1742: jtf_rs_roles_b rr,
1743: jtf_rs_groups_b rgb
1744: WHERE rgm.resource_id = g_user_resource_id
1745: AND nvl(rgm.delete_flag,'N') = 'N'
1746: AND rgd.group_id = rgm.group_id