508: SELECT dv.group_id
509: , dv.group_id PARENT_GROUP_ID
510: , NULL PARENT_GROUP_NAME
511: FROM jtf_rs_group_usages usg
512: , jtf_rs_groups_b dv
513: WHERE usg.usage = 'SALES'
514: AND usg.group_id = dv.group_id
515: ) SALES_GRPS
516: WHERE rol.member_flag = 'Y'