477: --
478: EXCEPTION
479: WHEN NO_DATA_FOUND THEN
480: pay_result_value := NULL;
481: hr_utility.trace('TEST pay_result_value : NULL ');
482: return pay_result_value;
483: --
484: END get_tax_details;
485: --
695: -- g_table_dim this variable holds the table dimension
696:
697: l_table_index := 1;
698: --
699: hr_utility.trace(' Index :' || TO_CHAR(l_table_index));
700: hr_utility.trace(' Dim :' || TO_CHAR(g_table_dim));
701: --
702: LOOP
703: IF l_table_index > g_table_dim THEN
696:
697: l_table_index := 1;
698: --
699: hr_utility.trace(' Index :' || TO_CHAR(l_table_index));
700: hr_utility.trace(' Dim :' || TO_CHAR(g_table_dim));
701: --
702: LOOP
703: IF l_table_index > g_table_dim THEN
704: EXIT;
708:
709: IF l_balance_name = p_balance_type AND l_balance_suffix = p_dimension_suffix THEN
710: l_result := g_balance_id(l_table_index);
711: l_found := TRUE;
712: hr_utility.trace(' FOUND !!!!! ');
713: EXIT;
714: END IF;
715: l_table_index := l_table_index + 1;
716: END LOOP;
714: END IF;
715: l_table_index := l_table_index + 1;
716: END LOOP;
717: --
718: hr_utility.trace(' Index :' || TO_CHAR(l_table_index));
719: --
720: IF l_found = FALSE THEN -- calculate and insert the new value in the table.
721: --
722: hr_utility.trace(' NOT FOUND, inserted IN position : ' || TO_CHAR(l_table_index));
718: hr_utility.trace(' Index :' || TO_CHAR(l_table_index));
719: --
720: IF l_found = FALSE THEN -- calculate and insert the new value in the table.
721: --
722: hr_utility.trace(' NOT FOUND, inserted IN position : ' || TO_CHAR(l_table_index));
723: --
724: open c_defined_balance;
725: fetch c_defined_balance into l_result;
726: close c_defined_balance;