APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_OM_OE_RMA_TAXES

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

2480: CURSOR check_rma_ref IS
2481: SELECT 1 from JAI_OM_OE_RMA_LINES
2482: WHERE TO_CHAR(RMA_NUMBER) IN (SELECT INTERFACE_HEADER_ATTRIBUTE1 FROM RA_CUSTOMER_TRX_ALL
2483: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID)
2484: AND Rma_line_id in ( Select RMA_LINE_ID from JAI_OM_OE_RMA_TAXES a,JAI_CMN_TAXES_ALL b
2485: Where a.tax_id = b.tax_id
2486: AND b.tax_type = jai_constants.tax_type_freight );
2487:
2488: --added 12-Mar-2002