DBA Data[Home] [Help]

APPS.JAI_JMCR_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

Line 82: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

78: where customer_trx_line_id =pr_new.ref_line_id);
79:
80: CURSOR Tax_Amount_Cur IS
81: SELECT sum(a.tax_amount) tax_amount
82: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
83: WHERE a.tax_id = b.tax_id
84: AND a.link_to_cust_trx_line_id = v_ref_line
85: AND b.tax_type NOT IN (
86: jai_constants.tax_type_tds ,