APPS.PAY_BATCH_BALANCEADJ_WRAPPER dependencies on PER_BUSINESS_GROUPS

Line 99: l_bg_name per_business_groups.name%TYPE;

95: p_batch_source in varchar2 default null,
96: p_batch_status in varchar2 default 'U',
97: p_batch_id out nocopy number ) is
98:
99: l_bg_name per_business_groups.name%TYPE;
100: l_batch_name pay_balance_batch_headers.batch_name%TYPE := null;
101:
102: l_new_header_id number;
103:

Line 115: from per_business_groups

111: hr_utility.trace('p_batch_id' || p_batch_id);
112:
113: -- hr_utility.trace_on(null,'webadi');
114: select name into l_bg_name
115: from per_business_groups
116: where business_group_id = p_business_group_id;
117:
118:
119: hr_utility.trace('l_batch_name, before selecting' || l_batch_name);

Line 193: l_bg_name per_business_groups.name%TYPE;

189: p_batch_source in varchar2 default hr_api.g_varchar2,
190: p_batch_status in varchar2 default hr_api.g_varchar2) is
191:
192: l_batch_status pay_balance_batch_headers.batch_status%TYPE;
193: l_bg_name per_business_groups.name%TYPE;
194: l_batch_name pay_balance_batch_headers.batch_name%TYPE := null;
195:
196:
197: Begin

Line 641: from per_business_groups

637:
638: -- Get the Cost Allocation Keyflex num
639: cursor c_get_caflexnum(cp_bg_id number) IS
640: select cost_allocation_structure
641: from per_business_groups
642: where business_group_id = cp_bg_id;
643:
644: -- Get the GRE ID based on GRE Name
645: cursor c_get_gre_id(cp_bg_id number,cp_gre_name varchar2) IS

Line 707: from per_business_groups

703: -- Added to know the legislation code for a business group
704:
705: cursor get_legislation_code IS
706: select legislation_code
707: from per_business_groups
708: where business_group_id = p_business_group_id;
709:
710:
711: /* cursor to get the assignment_id */