4108: c_fieldsales VARCHAR2, c_prm VARCHAR2, c_y VARCHAR2)
4109: IS
4110: SELECT grp.group_id
4111: FROM JTF_RS_GROUP_MEMBERS mem,
4112: JTF_RS_ROLE_RELATIONS rrel,
4113: JTF_RS_ROLES_B role,
4114: JTF_RS_GROUP_USAGES u,
4115: JTF_RS_GROUPS_B grp
4116: WHERE mem.group_member_id = rrel.role_resource_id