DBA Data[Home] [Help]

APPS.BIS_TARGET_LEVEL_PVT dependencies on BIS_INDICATOR_RESPS

Line 2399: delete from bis_indicator_resps

2395: , x_return_status
2396: , x_error_Tbl
2397: );
2398:
2399: delete from bis_indicator_resps
2400: where target_level_id = p_Target_Level_Rec.Target_Level_Id;
2401:
2402: if (p_commit = FND_API.G_TRUE) then
2403: COMMIT;

Line 3087: from bis_indicator_resps ir

3083: -- juwang bug#2225110 needs to check if end date and start date
3084: -- expires in fnd_user_resp_groups
3085: CURSOR ind_res IS
3086: select distinct ir.target_level_id, target_level_name
3087: from bis_indicator_resps ir
3088: , fnd_user_resp_groups ur
3089: , bisbv_target_levels il
3090: where ur.user_id = p_user_id
3091: and ir.responsibility_id = ur.responsibility_id