SELECT ASGD.PARENT_SALES_GROUP_ID , ASG.SALES_GROUP_ID , ASG.NAME , ASG.MANAGER_PERSON_ID FROM AS_SALES_GROUPS_DENORM ASGD , AS_SALES_GROUPS ASG WHERE ASGD.SALES_GROUP_ID = ASG.SALES_GROUP_ID AND ASG.ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , SYSDATE)