APPS.INV_DIAG_GRP dependencies on FND_USER_RESP_GROUPS
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