APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PER_BUSINESS_GROUPS

Line 123: select name from per_business_groups

119: --
120: l_db_name varchar2(30);
121: --
122: cursor c_bg(v_bg_id number) is
123: select name from per_business_groups
124: where business_group_id = v_bg_id ;
125: --
126: l_context_bg_name per_business_groups.name%type;
127: --

Line 126: l_context_bg_name per_business_groups.name%type;

122: cursor c_bg(v_bg_id number) is
123: select name from per_business_groups
124: where business_group_id = v_bg_id ;
125: --
126: l_context_bg_name per_business_groups.name%type;
127: --
128: begin
129: --
130: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 380: from per_business_groups bg

376: (information180 is not null and information176 is null));
377: --
378: cursor c_leg is
379: select bg.legislation_code
380: from per_business_groups bg
381: where bg.business_group_id = p_target_business_group_id; -- 9999
382: --
383: l_legislation_code varchar2(150);
384: --

Line 2435: from per_business_groups

2431: and cet.transaction_category_id = tcg.transaction_category_id;
2432:
2433: cursor c_business_group_name(c_business_group_id in number) is
2434: select name
2435: from per_business_groups
2436: where business_group_id = c_business_group_id;
2437:
2438: cursor c_lookup (c_lookup_type in varchar2
2439: ,c_lookup_code in varchar2) is

Line 2458: l_target_business_group_name per_business_groups.name%type;

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;
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);