APPS.INV_DIAG_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 165

select count(*)
into l_dummy
from fnd_user_resp_groups fg, fnd_responsibility_vl fr
where fg.RESPONSIBILITY_ID=fr.RESPONSIBILITY_ID
and nvl(fr.START_DATE, sysdate) <= sysdate
and nvl(fr.END_DATE, sysdate) >= sysdate
and nvl(fg.START_DATE, sysdate) <=sysdate
and nvl(fg.END_DATE, sysdate) >=sysdate
and fr.RESPONSIBILITY_NAME = p_responsibility_name
and user_id=fnd_global.user_id;