DBA Data[Home] [Help]

APPS.BSC_PORTLET_UI_WRAPPER dependencies on FND_RESPONSIBILITY

Line 244: FND_RESPONSIBILITY fr

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

Line 247: fnd.RESPONSIBILITY_ID = p_resp_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:

Line 248: fnd.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID AND

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