88:
89: /* Call to this function below implements Batch Balance Retrieval for better performance */
90:
91: g_context_table(1).tax_unit_id := p_registered_employer;
92: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
93: p_defined_balance_lst=>g_balance_value_tab,
94: p_context_lst =>g_context_table,
95: p_output_table=>g_result_table);
96:
127: p_taxable_income := nvl(g_result_table(11).balance_value,0);
128:
129: /* 14134526 - Fetching balances for each state */
130: if p_tax_state = 'VIC' THEN
131: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
132: p_defined_balance_lst=>g_balance_value_tab_vic,
133: p_context_lst =>g_context_table,
134: p_output_table=>g_result_table_state);
135:
133: p_context_lst =>g_context_table,
134: p_output_table=>g_result_table_state);
135:
136: elsif p_tax_state = 'NSW' THEN
137: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
138: p_defined_balance_lst=>g_balance_value_tab_nsw,
139: p_context_lst =>g_context_table,
140: p_output_table=>g_result_table_state);
141:
139: p_context_lst =>g_context_table,
140: p_output_table=>g_result_table_state);
141:
142: elsif p_tax_state = 'ACT' THEN
143: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
144: p_defined_balance_lst=>g_balance_value_tab_act,
145: p_context_lst =>g_context_table,
146: p_output_table=>g_result_table_state);
147:
145: p_context_lst =>g_context_table,
146: p_output_table=>g_result_table_state);
147:
148: elsif p_tax_state = 'SA' THEN
149: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
150: p_defined_balance_lst=>g_balance_value_tab_sa,
151: p_context_lst =>g_context_table,
152: p_output_table=>g_result_table_state);
153:
151: p_context_lst =>g_context_table,
152: p_output_table=>g_result_table_state);
153:
154: elsif p_tax_state = 'QLD' THEN
155: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
156: p_defined_balance_lst=>g_balance_value_tab_qld,
157: p_context_lst =>g_context_table,
158: p_output_table=>g_result_table_state);
159:
157: p_context_lst =>g_context_table,
158: p_output_table=>g_result_table_state);
159:
160: elsif p_tax_state = 'TAS' THEN
161: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
162: p_defined_balance_lst=>g_balance_value_tab_tas,
163: p_context_lst =>g_context_table,
164: p_output_table=>g_result_table_state);
165:
163: p_context_lst =>g_context_table,
164: p_output_table=>g_result_table_state);
165:
166: elsif p_tax_state = 'WA' THEN
167: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
168: p_defined_balance_lst=>g_balance_value_tab_wa,
169: p_context_lst =>g_context_table,
170: p_output_table=>g_result_table_state);
171:
169: p_context_lst =>g_context_table,
170: p_output_table=>g_result_table_state);
171:
172: elsif p_tax_state = 'NT' THEN
173: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
174: p_defined_balance_lst=>g_balance_value_tab_nt,
175: p_context_lst =>g_context_table,
176: p_output_table=>g_result_table_state);
177: end if;
805:
806: hr_utility.set_location('l_term_defined ' || l_term_defined_balance_id,99);
807: hr_utility.set_location('per_information ' || csr_le_rec.per_information2,99);
808:
809: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id,
810: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);
811:
812: /* 5139764 */
813:
810: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);
811:
812: /* 5139764 */
813:
814: l_term_balance_value := pay_balance_pkg.get_value(l_term_defined_balance_id,
815: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);
816:
817: /* 5139764 */
818:
815: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);
816:
817: /* 5139764 */
818:
819: l_elig_term_balance_value := pay_balance_pkg.get_value(l_elig_term_defined_balance_id,
820: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);
821:
822: hr_utility.set_location('l_balanace_value ' || l_balance_value,999);
823: