APPS.OKL_CS_LC_CONTRACT_PVT dependencies on JTF_RS_GROUPS_B

Line 1005: jtf_rs_groups_b rgb

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

Line 1024: jtf_rs_groups_b rgb

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'
1027: AND rgd.group_id = rgm.group_id
1028: AND rgd.parent_group_id = rgb.group_id