Need sql to find profile options assigned to a certain 'responsibility' under concurrent manager. Which tables contain this information?

Thank you for you help.