DBA Data[Home] [Help]

APPS.CSM_HA_EVENT_PKG dependencies on FND_USER_RESP_GROUPS

Line 405: FROM FND_USER_RESP_GROUPS usr_rsp,

401: /*
402: Assign HA responsibility to users mapped to corresponding non-HA responsibility
403: */
404: FOR rec IN (SELECT usr.USER_NAME,app.APPLICATION_SHORT_NAME app_name,mapp.HA_RESP_KEY resp_key
405: FROM FND_USER_RESP_GROUPS usr_rsp,
406: CSM_HA_RESP_MAPPINGS mapp,
407: FND_APPLICATION app,
408: FND_USER usr
409: WHERE SYSDATE BETWEEN nvl(usr_rsp.START_DATE,SYSDATE-1) AND nvl(usr_rsp.END_DATE,SYSDATE+1)

Line 414: AND NOT EXISTS (SELECT 1 FROM FND_USER_RESP_GROUPS

410: AND usr_rsp.USER_ID=usr.USER_ID
411: AND usr_rsp.RESPONSIBILITY_ID=mapp.RESPONSIBILITY_ID
412: AND usr_rsp.RESPONSIBILITY_APPLICATION_ID= mapp.APPLICATION_ID
413: AND mapp.HA_APPLICATION_ID=app.APPLICATION_ID
414: AND NOT EXISTS (SELECT 1 FROM FND_USER_RESP_GROUPS
415: WHERE USER_ID=usr.USER_ID
416: AND RESPONSIBILITY_ID=mapp.HA_RESPONSIBILITY_ID
417: AND RESPONSIBILITY_APPLICATION_ID=mapp.HA_APPLICATION_ID))
418: LOOP