DBA Data[Home] [Help]

APPS.IGS_EN_WORKFLOW dependencies on WF_LOCAL_USER_ROLES

Line 900: FROM WF_LOCAL_USER_ROLES

896:
897: CURSOR c_dup_user (cp_user_name VARCHAR2,
898: cp_role_name VARCHAR2) IS
899: SELECT count(1)
900: FROM WF_LOCAL_USER_ROLES
901: WHERE USER_NAME = cp_user_name
902: AND ROLE_NAME = cp_role_name
903: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
904: AND ROLE_ORIG_SYSTEM_ID = 0;

Line 1053: FROM WF_LOCAL_USER_ROLES

1049:
1050: CURSOR c_dup_user (cp_user_name VARCHAR2,
1051: cp_role_name VARCHAR2) IS
1052: SELECT count(1)
1053: FROM WF_LOCAL_USER_ROLES
1054: WHERE USER_NAME = cp_user_name
1055: AND ROLE_NAME = cp_role_name
1056: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
1057: AND ROLE_ORIG_SYSTEM_ID = 0;

Line 1204: FROM WF_LOCAL_USER_ROLES

1200:
1201: CURSOR c_dup_user (cp_user_name VARCHAR2,
1202: cp_role_name VARCHAR2) IS
1203: SELECT count(1)
1204: FROM WF_LOCAL_USER_ROLES
1205: WHERE USER_NAME = cp_user_name
1206: AND ROLE_NAME = cp_role_name
1207: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
1208: AND ROLE_ORIG_SYSTEM_ID = 0;

Line 1358: FROM WF_LOCAL_USER_ROLES

1354:
1355: CURSOR c_dup_user (cp_user_name VARCHAR2,
1356: cp_role_name VARCHAR2) IS
1357: SELECT count(1)
1358: FROM WF_LOCAL_USER_ROLES
1359: WHERE USER_NAME = cp_user_name
1360: AND ROLE_NAME = cp_role_name
1361: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
1362: AND ROLE_ORIG_SYSTEM_ID = 0;