APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on FND_USER_RESP_GROUPS

Line 2331: FND_USER_RESP_GROUPS resp

2327: cursor c_get_user_resp_value(p_user_id number) is
2328: select optval.PROFILE_OPTION_VALUE
2329: from FND_PROFILE_OPTION_VALUES optval,
2330: fnd_profile_options_vl opt,
2331: FND_USER_RESP_GROUPS resp
2332: where opt.profile_option_id = optval.profile_option_id
2333: and optval.level_value = resp.RESPONSIBILITY_ID
2334: and resp.user_id = p_user_id
2335: and opt.profile_option_name like 'PER_BUSINESS_GROUP_ID'

Line 2344: from fnd_user_resp_groups resp

2340: cursor c_get_user_resp_value(p_user_id number) is
2341: select resp.user_id,
2342: resp.responsibility_id,
2343: resp.responsibility_application_id application_id
2344: from fnd_user_resp_groups resp
2345: where resp.user_id = p_user_id;
2346: --
2347: l_business_group_id varchar2(30) ;
2348: --