DBA Data[Home] [Help]

APPS.ZPB_WF_EVENT dependencies on FND_USER_RESP_GROUPS

Line 380: from FND_USER_RESP_GROUPS g

376: respAppID :=210;
377:
378: select min(RESPONSIBILITY_ID)
379: into respID
380: from FND_USER_RESP_GROUPS g
381: where USER_ID = OwnerID and RESPONSIBILITY_APPLICATION_ID = respAppID
382: and g.RESPONSIBILITY_ID in (select r.RESPONSIBILITY_ID
383: from FND_RESPONSIBILITY r where RESPONSIBILITY_KEY in
384: ('ZPB_CONTROLLER_RESP', 'ZPB_SUPER_CONTROLLER_RESP', 'ZPB_MANAGER_RESP'));