14: p_element_name_prefix in varchar2)
15: ------------------------------------------------------------------------
16: is
17: l_proc varchar2(61) := c_package || 'create_bal_init_struct';
18: l_business_group_id per_business_groups_perf.business_group_id%TYPE;
19: l_business_group_name per_business_groups_perf.name%TYPE;
20: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
21: l_currency_code per_business_groups_perf.currency_code%TYPE;
22: l_classification_name pay_element_classifications.classification_name%TYPE;
15: ------------------------------------------------------------------------
16: is
17: l_proc varchar2(61) := c_package || 'create_bal_init_struct';
18: l_business_group_id per_business_groups_perf.business_group_id%TYPE;
19: l_business_group_name per_business_groups_perf.name%TYPE;
20: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
21: l_currency_code per_business_groups_perf.currency_code%TYPE;
22: l_classification_name pay_element_classifications.classification_name%TYPE;
23: l_element_type_id pay_element_types_f.element_type_id%TYPE;
16: is
17: l_proc varchar2(61) := c_package || 'create_bal_init_struct';
18: l_business_group_id per_business_groups_perf.business_group_id%TYPE;
19: l_business_group_name per_business_groups_perf.name%TYPE;
20: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
21: l_currency_code per_business_groups_perf.currency_code%TYPE;
22: l_classification_name pay_element_classifications.classification_name%TYPE;
23: l_element_type_id pay_element_types_f.element_type_id%TYPE;
24: l_element_name pay_element_types_f.element_name%TYPE;
17: l_proc varchar2(61) := c_package || 'create_bal_init_struct';
18: l_business_group_id per_business_groups_perf.business_group_id%TYPE;
19: l_business_group_name per_business_groups_perf.name%TYPE;
20: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
21: l_currency_code per_business_groups_perf.currency_code%TYPE;
22: l_classification_name pay_element_classifications.classification_name%TYPE;
23: l_element_type_id pay_element_types_f.element_type_id%TYPE;
24: l_element_name pay_element_types_f.element_name%TYPE;
25: l_element_link_id number;
35: pbg.legislation_code,
36: pec.classification_name,
37: pbg.currency_code
38: from pay_element_classifications pec,
39: per_business_groups_perf pbg,
40: pay_balance_batch_headers h
41: where h.batch_id = p_batch_id
42: and upper(pbg.name) = upper(h.business_group_name)
43: and pec.classification_id = p_classification_id