998: -- stored in pl/sql global table and this table is used for
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
1016: AND rrr.role_id = rr.role_id
1017: AND rr.role_type_code = 'CONTRACTS'
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