DBA Data[Home] [Help]

APPS.PAY_BATCH_ELEMENT_ENTRY_API dependencies on PER_BUSINESS_GROUPS

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

161: --
162: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
163: l_element_name pay_element_types_f.element_name%TYPE := null;
164: l_count number := 0;
165: l_legislation_code per_business_groups.legislation_code%TYPE := null;
166: l_business_group_id per_business_groups.business_group_id%TYPE;
167: l_batch_id pay_batch_lines.batch_id%TYPE;
168: l_effective_date pay_batch_lines.effective_date%TYPE;
169: --

Line 166: l_business_group_id per_business_groups.business_group_id%TYPE;

162: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
163: l_element_name pay_element_types_f.element_name%TYPE := null;
164: l_count number := 0;
165: l_legislation_code per_business_groups.legislation_code%TYPE := null;
166: l_business_group_id per_business_groups.business_group_id%TYPE;
167: l_batch_id pay_batch_lines.batch_id%TYPE;
168: l_effective_date pay_batch_lines.effective_date%TYPE;
169: --
170: cursor csr_element_type (p_ele_name varchar2

Line 240: from per_business_groups pbg,

236: end if;
237: --
238: select pbg.business_group_id,pbg.legislation_code
239: into l_business_group_id,l_legislation_code
240: from per_business_groups pbg,
241: pay_batch_headers pbh
242: where pbh.batch_id = l_batch_id
243: and pbg.business_group_id = pbh.business_group_id;
244: --