APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on FND_USER

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: --

Line 2454: from fnd_user

2450: from dual ;
2451:
2452: cursor c_run_by(c_user_id in number) is
2453: select user_name
2454: from fnd_user
2455: where user_id = c_user_id;
2456:
2457: l_copy_entity_txn c_copy_entity_txn%rowtype;
2458: l_target_business_group_name per_business_groups.name%type;

Line 2463: l_run_by fnd_user.user_name%type;

2459: l_reuse_option hr_lookups.meaning%type;
2460: l_prefix_suffix_option hr_lookups.meaning%type;
2461: l_run_date varchar2(50);
2462: l_run_time varchar2(50);
2463: l_run_by fnd_user.user_name%type;
2464:
2465: cursor c_table_route is
2466: select table_alias
2467: ,display_name