DBA Data[Home] [Help]

APPS.BIS_PMF_DEFINER_WRAPPER_PVT dependencies on BIS_INDICATOR_RESPS

Line 2550: FROM bis_indicator_Resps

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
2551: WHERE target_level_id=p_target_level_id;
2552: l_parameter_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
2553: l_parameter_set_exist BOOLEAN;
2554: l_notifiers_code VARCHAR2(32000);

Line 2979: and target_level_id in (select distinct ir.target_level_id from bis_indicator_resps ir

2975: l_has_auth NUMBER;
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