DBA Data[Home] [Help]

APPS.IGS_AS_NOTIFY_STUDENT dependencies on WF_LOCAL_USER_ROLES

Line 122: FROM WF_LOCAL_USER_ROLES

118:
119: CURSOR c_dup_user (cp_user_name VARCHAR2,
120: cp_role_name VARCHAR2) IS
121: SELECT count(1)
122: FROM WF_LOCAL_USER_ROLES
123: WHERE USER_NAME = cp_user_name
124: AND ROLE_NAME = cp_role_name
125: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
126: AND ROLE_ORIG_SYSTEM_ID = 0;

Line 464: FROM WF_LOCAL_USER_ROLES

460:
461: CURSOR c_dup_user (cp_user_name VARCHAR2,
462: cp_role_name VARCHAR2) IS
463: SELECT count(1)
464: FROM WF_LOCAL_USER_ROLES
465: WHERE USER_NAME = cp_user_name
466: AND ROLE_NAME = cp_role_name
467: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
468: AND ROLE_ORIG_SYSTEM_ID = 0;