You have to pass user name as parameter
SELECT B.RESPONSIBILITY_NAME NAME,
FROM APPS.FND_USER_RESP_GROUPS A,
WHERE A.USER_ID = U.USER_ID
AND U.USER_ID = (SELECT USER_ID FROM FND_USER WHERE USER_NAME=:USER_NAME)
AND A.RESPONSIBILITY_ID = B.RESPONSIBILITY_ID
AND A.RESPONSIBILITY_APPLICATION_ID = B.APPLICATION_ID
AND SYSDATE BETWEEN A.START_DATE AND NVL (A.END_DATE, SYSDATE + 1)
AND B.END_DATE IS NULL
AND U.END_DATE IS NULL
NOTE: If you consider your question/issue as answered/solved, please, rate this answer as Correct or Helpful.
This will help to the rest of customers to find correct answers easily. Thanks!
If you are talking abt vacation rule, then you may refer to WF_ROUTING_RULES table.
Sent from my iPhone
Thanks for reply. I am searching for same.
1 person found this helpful
Good to know that Afsar.
Would you mind flagging it as Helpful/Answered.