APPS.PAY_KR_BAL_INIT_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 22: l_classification_name pay_element_classifications.classification_name%TYPE;

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;
26: l_input_value_id number;

Line 38: from pay_element_classifications pec,

34: pbg.name,
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)

Line 66: from pay_element_classifications pec,

62: and nvl(pbt.business_group_id, l_business_group_id) = l_business_group_id
63: and nvl(pbt.legislation_code, l_legislation_code) = l_legislation_code
64: and not exists(
65: select null
66: from pay_element_classifications pec,
67: pay_element_types_f pet,
68: pay_input_values_f piv,
69: pay_balance_feeds_f pbf
70: where pbf.balance_type_id = pbt.balance_type_id