DBA Data[Home] [Help]

APPS.IGS_RE_WORKFLOW dependencies on WF_LOCAL_USER_ROLES

Line 682: FROM WF_LOCAL_USER_ROLES

678:
679: CURSOR c_dup_user (cp_user_name VARCHAR2,
680: cp_role_name VARCHAR2) IS
681: SELECT count(1)
682: FROM WF_LOCAL_USER_ROLES
683: WHERE USER_NAME = cp_user_name
684: AND ROLE_NAME = cp_role_name
685: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
686: AND ROLE_ORIG_SYSTEM_ID = 0;

Line 840: FROM WF_LOCAL_USER_ROLES

836:
837: CURSOR c_dup_user (cp_user_name VARCHAR2,
838: cp_role_name VARCHAR2) IS
839: SELECT count(1)
840: FROM WF_LOCAL_USER_ROLES
841: WHERE USER_NAME = cp_user_name
842: AND ROLE_NAME = cp_role_name
843: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
844: AND ROLE_ORIG_SYSTEM_ID = 0;

Line 1036: FROM WF_LOCAL_USER_ROLES

1032:
1033: CURSOR c_dup_user (cp_user_name VARCHAR2,
1034: cp_role_name VARCHAR2) IS
1035: SELECT count(1)
1036: FROM WF_LOCAL_USER_ROLES
1037: WHERE USER_NAME = cp_user_name
1038: AND ROLE_NAME = cp_role_name
1039: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
1040: AND ROLE_ORIG_SYSTEM_ID = 0;

Line 1372: FROM WF_LOCAL_USER_ROLES

1368:
1369: CURSOR c_dup_user (cp_user_name VARCHAR2,
1370: cp_role_name VARCHAR2) IS
1371: SELECT count(1)
1372: FROM WF_LOCAL_USER_ROLES
1373: WHERE USER_NAME = cp_user_name
1374: AND ROLE_NAME = cp_role_name
1375: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
1376: AND ROLE_ORIG_SYSTEM_ID = 0;

Line 2525: FROM WF_LOCAL_USER_ROLES

2521:
2522: CURSOR c_dup_user (cp_user_name VARCHAR2,
2523: cp_role_name VARCHAR2) IS
2524: SELECT count(1)
2525: FROM WF_LOCAL_USER_ROLES
2526: WHERE USER_NAME = cp_user_name
2527: AND ROLE_NAME = cp_role_name
2528: AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
2529: AND ROLE_ORIG_SYSTEM_ID = 0;