APPS.PQH_WF dependencies on PQH_ROLE_USERS_V

Line 2714: FROM pqh_role_users_v

2710: WHERE transaction_category_id = p_transaction_category_id;
2711:
2712: cursor c_get_user_role (p_user_id NUMBER) is
2713: SELECT role_id
2714: FROM pqh_role_users_v
2715: WHERE user_id = p_user_id
2716: AND nvl(default_role,'X') = 'Y';
2717:
2718: cursor c_get_assignment (p_user_id NUMBER) IS

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

2735: FETCH c_get_txn_cat INTO l_member_cd, l_workflow_enable_flag;
2736: CLOSE c_get_txn_cat;
2737: IF NVL(l_workflow_enable_flag, 'N') = 'Y' THEN
2738: IF l_member_cd = 'R' THEN
2739: -- use the view pqh_role_users_v for selecting the default role of the user
2740: OPEN c_get_user_role(p_user_id => p_user_id);
2741: FETCH c_get_user_role INTO l_role_id;
2742: CLOSE c_get_user_role;
2743: ELSIF l_member_cd in ('P','S') then