APPS.JAI_AR_UTILS_PKG dependencies on JAI_AR_TRX_TAX_LINES

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 849: UPDATE JAI_AR_TRX_TAX_LINES

845:
846: IF transaction_name = 'AR_LINES_UPDATE'
847: THEN
848: IF NVL(rec.adhoc_flag,'N') = 'Y' THEN
849: UPDATE JAI_AR_TRX_TAX_LINES
850: SET tax_amount = nvl(rec.tax_amount,0),
851: base_tax_amount = nvl(rec.base_tax_amount,0),
852: func_tax_amount = nvl(rec.func_tax_amount,0),
853: last_update_date = p_last_update_date,

Line 859: UPDATE JAI_AR_TRX_TAX_LINES

855: last_update_login = p_last_update_login
856: WHERE link_to_cust_trx_line_id = P_line_id
857: AND tax_line_no = rec.lno;
858: ELSE
859: UPDATE JAI_AR_TRX_TAX_LINES
860: SET tax_amount = nvl(tax_amt_tab(rec.lno),0),
861: base_tax_amount = decode(nvl(base_tax_amt_tab(rec.lno), 0), 0, nvl(tax_amt_tab(rec.lno),0), nvl(base_tax_amt_tab(rec.lno), 0)),
862: func_tax_amount = ROUND(nvl(tax_amt_tab(rec.lno),0) * v_currency_conv_factor, rounding_factor_tab(rec.lno)),
863: last_update_date = p_last_update_date,