DBA Data[Home] [Help]

APPS.OTA_EL_ENROLL_SS dependencies on FND_USER_RESP_GROUPS

Line 2304: fnd_user_resp_groups furg,

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