APPS.PA_CANDIDATE_PUB dependencies on WF_USER_ROLES

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

3316:
3317: -- Get all users attached to Adhoc role
3318: WF_DIRECTORY.GETROLEUSERS(l_role_name, user_table);
3319:
3320: -- Get PER role for the 'nth' user from WF_USER_ROLES
3321: SELECT ROLE_NAME
3322: INTO l_role_name_temp
3323: FROM WF_USER_ROLES
3324: WHERE USER_NAME = user_table(l_nf_loop_counter)

Line 3323: FROM WF_USER_ROLES

3319:
3320: -- Get PER role for the 'nth' user from WF_USER_ROLES
3321: SELECT ROLE_NAME
3322: INTO l_role_name_temp
3323: FROM WF_USER_ROLES
3324: WHERE USER_NAME = user_table(l_nf_loop_counter)
3325: AND USER_ORIG_SYSTEM = 'PER'
3326: AND ROLE_ORIG_SYSTEM = 'PER'
3327: AND ROWNUM = 1;