730: fetch csr_get_defined_bal_id into g_hours_absent_def_bal_id;
731: close csr_get_defined_bal_id;
732: end if;
733: --
734: pay_balance_pkg.set_context ('SOURCE_TEXT',p_process_type);
735: pay_balance_pkg.set_context ('TAX_UNIT_ID',p_tax_unit_id);
736: l_result := nvl(pay_balance_pkg.get_value(g_hours_worked_def_bal_id,
737: l_assignment_action_id),0) +
738: nvl(pay_balance_pkg.get_value(g_hours_absent_def_bal_id,
731: close csr_get_defined_bal_id;
732: end if;
733: --
734: pay_balance_pkg.set_context ('SOURCE_TEXT',p_process_type);
735: pay_balance_pkg.set_context ('TAX_UNIT_ID',p_tax_unit_id);
736: l_result := nvl(pay_balance_pkg.get_value(g_hours_worked_def_bal_id,
737: l_assignment_action_id),0) +
738: nvl(pay_balance_pkg.get_value(g_hours_absent_def_bal_id,
739: l_assignment_action_id),0);
732: end if;
733: --
734: pay_balance_pkg.set_context ('SOURCE_TEXT',p_process_type);
735: pay_balance_pkg.set_context ('TAX_UNIT_ID',p_tax_unit_id);
736: l_result := nvl(pay_balance_pkg.get_value(g_hours_worked_def_bal_id,
737: l_assignment_action_id),0) +
738: nvl(pay_balance_pkg.get_value(g_hours_absent_def_bal_id,
739: l_assignment_action_id),0);
740: return l_result;
734: pay_balance_pkg.set_context ('SOURCE_TEXT',p_process_type);
735: pay_balance_pkg.set_context ('TAX_UNIT_ID',p_tax_unit_id);
736: l_result := nvl(pay_balance_pkg.get_value(g_hours_worked_def_bal_id,
737: l_assignment_action_id),0) +
738: nvl(pay_balance_pkg.get_value(g_hours_absent_def_bal_id,
739: l_assignment_action_id),0);
740: return l_result;
741: --
742: else