DBA Data[Home] [Help]

APPS.MSC_ST_UTIL dependencies on FND_USER_RESP_GROUPS

Line 2791: FROM FND_USER_RESP_GROUPS

2787:
2788: BEGIN
2789:
2790: select COUNT(*) into lv_cnt
2791: FROM FND_USER_RESP_GROUPS
2792: WHERE user_id IN (select USER_ID from MSC_COMPANY_USERS where user_id = p_user_id AND company_id = 1)
2793: AND responsibility_id = (SELECT responsibility_id FROM FND_RESPONSIBILITY WHERE responsibility_key = 'MSCX_SC_ADMIN_FULL')
2794: AND SYSDATE between start_date and decode(end_date,NULL,SYSDATE) ;
2795: