APPS.PQH_WF dependencies on PQH_ROLE_USERS_V

Line 2720: FROM pqh_role_users_v

2716: WHERE transaction_category_id = p_transaction_category_id;
2717:
2718: cursor c_get_user_role (p_user_id NUMBER) is
2719: SELECT role_id
2720: FROM pqh_role_users_v
2721: WHERE user_id = p_user_id
2722: AND nvl(default_role,'X') = 'Y';
2723:
2724: cursor c_get_assignment (p_user_id NUMBER) IS

Line 2747: -- use the view pqh_role_users_v for selecting the default role of the user

2743: CLOSE c_get_txn_cat;
2744: hr_utility.set_location('l_member_cd '||l_member_cd,9999);
2745: IF NVL(l_workflow_enable_flag, 'N') = 'Y' THEN
2746: IF l_member_cd = 'R' THEN
2747: -- use the view pqh_role_users_v for selecting the default role of the user
2748: OPEN c_get_user_role(p_user_id => p_user_id);
2749: FETCH c_get_user_role INTO l_role_id;
2750: CLOSE c_get_user_role;
2751: hr_utility.set_location('l_role_id '||l_role_id,9997);