SELECT TO_NUMBER(LTRIM(RTRIM(V.PROFILE_OPTION_VALUE))) , V.LEVEL_VALUE FROM FND_PROFILE_OPTIONS P , FND_PROFILE_OPTION_VALUES V WHERE P.PROFILE_OPTION_NAME = 'PER_BUSINESS_GROUP_ID' AND P.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID AND V.LEVEL_ID = 10003 UNION SELECT TO_NUMBER(LTRIM(RTRIM(V.PROFILE_OPTION_VALUE))) ORGANIZATION_ID , R.RESPONSIBILITY_ID RESPONSIBILITY_ID FROM FND_PROFILE_OPTIONS P , FND_PROFILE_OPTION_VALUES V , FND_RESPONSIBILITY R WHERE P.PROFILE_OPTION_NAME = 'PER_BUSINESS_GROUP_ID' AND P.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID AND V.LEVEL_ID = 10001 AND NOT EXISTS (SELECT 1 FROM FND_PROFILE_OPTION_VALUES V1 WHERE V1.PROFILE_OPTION_ID = P.PROFILE_OPTION_ID AND V1.LEVEL_ID = 10003 AND V1.LEVEL_VALUE = R.RESPONSIBILITY_ID)