Annotation: core.get_income_tax_provison_amount

CREATE OR REPLACE FUNCTION core.get_income_tax_provison_amount(_office_id integer, _profit numeric, _balance numeric)
RETURNS numeric

Information: core.get_income_tax_provison_amount

Schema	core
Function Name	get_income_tax_provison_amount
Arguments	_office_id integer, _profit numeric, _balance numeric
Owner	postgres
Result Type	numeric
Description

Implementation: core.get_income_tax_provison_amount

CREATE OR REPLACE FUNCTION core.get_income_tax_provison_amount(_office_id integer, _profit numeric, _balance numeric)
 RETURNS numeric
 LANGUAGE plpgsql
AS $function$
    DECLARE _rate real;
BEGIN
    _rate := core.get_income_tax_rate(_office_id);

    RETURN
    (
        (_profit * _rate/100) - _balance
    );
END
$function$