DBA Data[Home] [Help]

APPS.JAI_APTAX_PKG_CLIENT_EXTN SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

			    --select tax_amount from jai_ap_match_inv_taxes where invoice_id= and line_number=value_in_precedence_1 and tax_id=
 --step 3.2 :get the total tax target amount by summing the amounts fetched in step 3.2
--step 3.3 : get the tax amount by applying the tax rate to the tax target amount retrieved in step 3.2
-- step 3.4 : procedure shall return the tax_amount
NULL;