APPS.PAY_KR_BAL_INIT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 23: l_element_type_id pay_element_types_f.element_type_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;
27: l_counter number;

Line 24: l_element_name pay_element_types_f.element_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;
27: l_counter number;
28: l_dummy varchar2(255);

Line 67: pay_element_types_f pet,

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
71: and pbf.effective_start_date = c_sot

Line 97: from pay_element_types_f

93: l_max_seq number;
94: l_seq number;
95: cursor csr_et is
96: select element_name
97: from pay_element_types_f
98: where element_name like replace(p_element_name, '_', '\_') || '%' escape '\';
99: begin
100: l_max_seq := 1;
101: p_element_name := p_element_name_prefix || '_';

Line 134: update pay_element_types_f

130: p_process_in_run_flag => 'Y',
131: p_business_group_name => l_business_group_name,
132: p_post_termination_rule => 'Final Close');
133: --
134: update pay_element_types_f
135: set element_information1 = 'B'
136: where element_type_id = p_element_type_id;
137: --
138: p_element_link_id := pay_db_pay_setup.create_element_link(