DBA Data[Home] [Help]

APPS.INV_DIAG_GRP dependencies on FND_RESPONSIBILITY_VL

Line 167: from fnd_user_resp_groups fg, fnd_responsibility_vl fr

163: begin
164:
165: select count(*)
166: into l_dummy
167: from fnd_user_resp_groups fg, fnd_responsibility_vl fr
168: where fg.RESPONSIBILITY_ID=fr.RESPONSIBILITY_ID
169: and nvl(fr.START_DATE, sysdate) <= sysdate
170: and nvl(fr.END_DATE, sysdate) >= sysdate
171: and nvl(fg.START_DATE, sysdate) <=sysdate