240: INTO
241: l_count
242: FROM
243: FND_USER_RESP_GROUPS fnd,
244: FND_RESPONSIBILITY fr
245: WHERE
246: fnd.USER_ID = p_user_id AND
247: fnd.RESPONSIBILITY_ID = p_resp_id AND
248: fnd.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID AND
243: FND_USER_RESP_GROUPS fnd,
244: FND_RESPONSIBILITY fr
245: WHERE
246: fnd.USER_ID = p_user_id AND
247: fnd.RESPONSIBILITY_ID = p_resp_id AND
248: fnd.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID AND
249: SYSDATE BETWEEN fr.START_DATE AND NVL(fr.END_DATE, SYSDATE) AND
250: SYSDATE BETWEEN fnd.START_DATE AND NVL(fnd.END_DATE, SYSDATE);
251:
244: FND_RESPONSIBILITY fr
245: WHERE
246: fnd.USER_ID = p_user_id AND
247: fnd.RESPONSIBILITY_ID = p_resp_id AND
248: fnd.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID AND
249: SYSDATE BETWEEN fr.START_DATE AND NVL(fr.END_DATE, SYSDATE) AND
250: SYSDATE BETWEEN fnd.START_DATE AND NVL(fnd.END_DATE, SYSDATE);
251:
252: IF (l_count = 0) THEN