SELECT TO_CHAR(ASG.SALES_GROUP_ID) ID , ASG.NAME VALUE , FNUR.RESPONSIBILITY_ID FROM AS_SALES_GROUPS ASG , AS_SALESFORCE ASF , FND_USER FNU , FND_USER_RESP_GROUPS FNUR WHERE ASG.SALES_GROUP_ID = ASF.SALES_GROUP_ID AND ASF.EMPLOYEE_PERSON_ID = FNU.EMPLOYEE_ID AND FNU.USER_ID = FND_PROFILE.VALUE_WNPS( 'USER_ID') AND FNU.USER_ID = FNUR.USER_ID AND NOT EXISTS ( SELECT 'Y' FROM AS_SALES_GROUPS ASG1 WHERE ASG1.ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN ASG1.START_DATE_ACTIVE AND NVL(ASG1.END_DATE_ACTIVE , SYSDATE ) AND ASG1.MANAGER_PERSON_ID = ASF.EMPLOYEE_PERSON_ID ) UNION SELECT TO_CHAR(ASMGR.SALES_GROUP_ID ) , ASMGR.NAME VALUE , FNUR2.RESPONSIBILITY_ID FROM AS_SALES_GROUPS ASMGR , FND_USER FNU , FND_USER_RESP_GROUPS FNUR2 WHERE ASMGR.MANAGER_PERSON_ID = FNU.EMPLOYEE_ID AND ASMGR.ENABLED_FLAG = 'Y' AND TRUNC( SYSDATE) BETWEEN ASMGR.START_DATE_ACTIVE AND NVL( ASMGR.END_DATE_ACTIVE , SYSDATE ) AND FNU.USER_ID = FND_PROFILE.VALUE_WNPS( 'USER_ID') AND FNU.USER_ID = FNUR2.USER_ID