TO KNOW THE HOW MANY USERS HAVING THAT PARTICULAR RESPONSIBILITY
------------------------------------------------------------------------------------------------
SELECT FR.RESPONSIBILITY_NAME,
 FU.USER_NAME,
 FUR.START_DATE,
 FUR.END_DATE
 FROM
 FND_USER_RESP_GROUPS_DIRECT FUR,
 APPS.FND_RESPONSIBILITY_TL FR
 ,FND_USER FU
 WHERE FUR.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID
 AND FR.RESPONSIBILITY_NAME LIKE '%AP%'
 AND FUR.USER_ID = FU.USER_ID
 AND FUR.END_DATE IS NULL