DBA Data[Home] [Help]

APPS.PAY_BATCH_ELEMENT_ENTRY_API dependencies on PER_BUSINESS_GROUPS

Line 180: l_legislation_code per_business_groups.legislation_code%TYPE := null;

176: --
177: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
178: l_element_name pay_element_types_f.element_name%TYPE := null;
179: l_count number := 0;
180: l_legislation_code per_business_groups.legislation_code%TYPE := null;
181: l_business_group_id per_business_groups.business_group_id%TYPE;
182: l_batch_id pay_batch_lines.batch_id%TYPE;
183: l_effective_date pay_batch_lines.effective_date%TYPE;
184: l_date_prof_value varchar2(80);

Line 181: l_business_group_id per_business_groups.business_group_id%TYPE;

177: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
178: l_element_name pay_element_types_f.element_name%TYPE := null;
179: l_count number := 0;
180: l_legislation_code per_business_groups.legislation_code%TYPE := null;
181: l_business_group_id per_business_groups.business_group_id%TYPE;
182: l_batch_id pay_batch_lines.batch_id%TYPE;
183: l_effective_date pay_batch_lines.effective_date%TYPE;
184: l_date_prof_value varchar2(80);
185: --

Line 265: from per_business_groups pbg,

261: end if;
262: --
263: select pbg.business_group_id,pbg.legislation_code
264: into l_business_group_id,l_legislation_code
265: from per_business_groups pbg,
266: pay_batch_headers pbh
267: where pbh.batch_id = l_batch_id
268: and pbg.business_group_id = pbh.business_group_id;
269: --