DBA Data[Home] [Help]

APPS.INV_DIAG_GRP dependencies on FND_USER_RESP_GROUPS

Line 172: from fnd_user_resp_groups fg, fnd_responsibility_vl fr

168: begin
169:
170: select count(*)
171: into l_dummy
172: from fnd_user_resp_groups fg, fnd_responsibility_vl fr
173: where fg.RESPONSIBILITY_ID=fr.RESPONSIBILITY_ID
174: and nvl(fr.START_DATE, sysdate) <= sysdate
175: and nvl(fr.END_DATE, sysdate) >= sysdate
176: and nvl(fg.START_DATE, sysdate) <=sysdate