DBA Data[Home] [Help]

APPS.JAI_AR_UTILS_PKG dependencies on JAI_CMN_TAXES_ALL

Line 119: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b ,

115: )
116: )tax_type_val,
117: b.mod_cr_Percentage, b.vendor_id, b.tax_type
118: , b.inclusive_tax_flag -- Added by Jia Li for Tax Inclusive Computations on 2007/12/11
119: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b ,
120: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
121: WHERE a.link_to_cust_trx_line_id = p_line_id
122: AND a.tax_id = b.tax_id
123: AND rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/

Line 168: JAI_CMN_TAXES_ALL table based on the tax type column.

164:
165: This needs to be used for the calculation of the taxes registered under vat regime.
166:
167: This change has been done by using the view jai_regime_tax_types_v - and outer joining it with the
168: JAI_CMN_TAXES_ALL table based on the tax type column.
169:
170: Added a parameter p_vat_assessable_Value NUMBER for this procedure.
171:
172: Dependency due to this bug - Huge