Finding Responsibilities assigned to a user

SELECT fu.user_name ,
frt.responsibility_name,
furg.start_date,
FURG.END_DATE
FROM APPS.FND_USER FU ,
APPS.FND_USER_RESP_GROUPS_DIRECT FURG ,
apps.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;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s