DBA Data[Home] [Help]

APPS.PAY_KR_BAL_INIT_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 18: l_business_group_id per_business_groups_perf.business_group_id%TYPE;

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;

Line 19: l_business_group_name per_business_groups_perf.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;

Line 20: l_legislation_code per_business_groups_perf.legislation_code%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;

Line 21: l_currency_code per_business_groups_perf.currency_code%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;

Line 39: per_business_groups_perf pbg,

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