DBA Data[Home] [Help]

APPS.JAI_JMCR_TRIGGER_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 76: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b

72: where customer_trx_line_id =pr_new.ref_line_id);
73:
74: CURSOR Tax_Amount_Cur IS
75: SELECT sum(a.tax_amount) tax_amount
76: FROM JAI_AR_TRX_TAX_LINES a, JAI_CMN_TAXES_ALL b
77: WHERE a.tax_id = b.tax_id
78: AND a.link_to_cust_trx_line_id = v_ref_line
79: AND b.tax_type NOT IN (
80: jai_constants.tax_type_tds ,