DBA Data[Home] [Help]

APPS.MSC_ST_UTIL dependencies on FND_RESPONSIBILITY

Line 2753: AND responsibility_id = (SELECT responsibility_id FROM FND_RESPONSIBILITY WHERE responsibility_key = 'MSCX_SC_ADMIN_FULL')

2749:
2750: select COUNT(*) into lv_cnt
2751: FROM FND_USER_RESP_GROUPS
2752: WHERE user_id IN (select USER_ID from MSC_COMPANY_USERS where user_id = p_user_id AND company_id = 1)
2753: AND responsibility_id = (SELECT responsibility_id FROM FND_RESPONSIBILITY WHERE responsibility_key = 'MSCX_SC_ADMIN_FULL')
2754: AND SYSDATE between start_date and decode(end_date,NULL,SYSDATE) ;
2755:
2756: IF lv_cnt > 0 THEN
2757: RETURN TRUE;