DBA Data[Home] [Help]

APPS.JAI_AR_UTILS_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 144: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/

140: )tax_type_val,
141: b.mod_cr_Percentage, b.vendor_id, b.tax_type
142: , b.inclusive_tax_flag -- Added by Jia Li for Tax Inclusive Computations on 2007/12/11
143: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b ,
144: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
145: WHERE a.link_to_cust_trx_line_id = p_line_id
146: AND a.tax_id = b.tax_id
147: AND rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
148: ORDER BY a.tax_line_no;

Line 194: This change has been done by using the view jai_regime_tax_types_v - and outer joining it with the

190: has been given to capture the vat assessable value.
191:
192: This needs to be used for the calculation of the taxes registered under vat regime.
193:
194: This change has been done by using the view jai_regime_tax_types_v - and outer joining it with the
195: JAI_CMN_TAXES_ALL table based on the tax type column.
196:
197: Added a parameter p_vat_assessable_Value NUMBER for this procedure.
198: