DBA Data[Home] [Help]

APPS.OTA_EL_ENROLL_SS dependencies on FND_USER_RESP_GROUPS

Line 2306: fnd_user_resp_groups furg,

2302: cursor getResp(l_user_id in varchar2) is
2303: select fr.menu_id, furg.responsibility_id,
2304: furg.security_group_id, furg.responsibility_application_id
2305: from fnd_responsibility fr,
2306: fnd_user_resp_groups furg,
2307: fnd_user fu
2308: where fu.USER_ID = l_user_id
2309: and fu.START_DATE <= sysdate
2310: and (fu.END_DATE is null or fu.END_DATE > sysdate)