Get List of responsibilities assigned to a user

SELECT FU.USER_NAME, FRT.RESPONSIBILITY_NAME, FURG.START_DATE, FURG.END_DATE FROM FND_USER FU, FND_USER_RESP_GROUPS_DIRECT FURG, FND_RESPONSIBILITY_VL FRT WHERE FU.USER_ID = FURG.USER_ID AND FRT.RESPONSIBILITY_ID = FURG.RESPONSIBILITY_ID AND FRT.APPLICATION_ID = FURG.RESPONSIBILITY_APPLICATION_ID AND NVL (FURG.END_DATE, SYSDATE + 1) > SYSDATE AND NVL (FRT.END_DATE, SYSDATE + 1) > SYSDATE AND FU.USER_NAME = :P_USER_NAME