APPS.PA_CANDIDATE_PUB dependencies on WF_USER_ROLES

Line 3057: -- Get PER role for the 'nth' user from WF_USER_ROLES

3053:
3054: -- Get all users attached to Adhoc role
3055: WF_DIRECTORY.GETROLEUSERS(l_role_name, user_table);
3056:
3057: -- Get PER role for the 'nth' user from WF_USER_ROLES
3058: SELECT ROLE_NAME
3059: INTO l_role_name_temp
3060: FROM WF_USER_ROLES
3061: WHERE USER_NAME = user_table(l_nf_loop_counter)

Line 3060: FROM WF_USER_ROLES

3056:
3057: -- Get PER role for the 'nth' user from WF_USER_ROLES
3058: SELECT ROLE_NAME
3059: INTO l_role_name_temp
3060: FROM WF_USER_ROLES
3061: WHERE USER_NAME = user_table(l_nf_loop_counter)
3062: AND USER_ORIG_SYSTEM = 'PER'
3063: AND ROLE_ORIG_SYSTEM = 'PER'
3064: AND ROWNUM = 1;