APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_OM_OE_RMA_TAXES

Line 3395: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b

3391: CURSOR check_rma_ref IS
3392: SELECT 1 from JAI_OM_OE_RMA_LINES
3393: WHERE TO_CHAR(RMA_NUMBER) IN (SELECT INTERFACE_HEADER_ATTRIBUTE1 FROM RA_CUSTOMER_TRX_ALL
3394: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID)
3395: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b
3396: Where a.tax_id = b.tax_id
3397: AND b.tax_type = jai_constants.tax_type_freight );
3398:
3399: --added 12-Mar-2002