DBA Data[Home] [Help]

APPS.BIS_PMF_DEFINER_WRAPPER_PVT dependencies on FND_USER_RESP_GROUPS

Line 2546: FROM fnd_user_resp_groups

2542: FROM bis_levels
2543: WHERE short_name=p_dim_level_short_name;
2544: CURSOR c_resp IS
2545: SELECT responsibility_id
2546: FROM fnd_user_resp_groups
2547: WHERE user_id=p_user_id;
2548: CURSOR c_indresp(p_target_level_id IN NUMBER) IS
2549: SELECT responsibility_id
2550: FROM bis_indicator_Resps

Line 2980: , fnd_user_resp_groups ur

2976:
2977: cursor cr_tar_auth is
2978: select target_level_id from bisfv_target_levels where measure_id = p_measure_id
2979: and target_level_id in (select distinct ir.target_level_id from bis_indicator_resps ir
2980: , fnd_user_resp_groups ur
2981: , bisbv_target_levels il
2982: where ur.user_id = p_user_id
2983: and ir.responsibility_id = ur.responsibility_id
2984: and il.target_level_id = ir.target_level_id and il.target_level_id=p_target_level_id);