DBA Data[Home] [Help]

APPS.BIS_TARGET_LEVEL_PVT dependencies on FND_USER_RESP_GROUPS

Line 3084: -- expires in fnd_user_resp_groups

3080: )
3081: IS
3082: l_flag NUMBER :=0;
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

Line 3088: , fnd_user_resp_groups ur

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
3092: AND ur.start_date <= sysdate