APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 2490: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B

2486: AND b.tax_type = jai_constants.tax_type_freight );
2487:
2488: --added 12-Mar-2002
2489: CURSOR tax_type IS SELECT b.tax_type t_type,a.customer_trx_line_id line_id
2490: FROM JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B
2491: WHERE link_to_cust_trx_line_id = p_link_line_id
2492: and A.tax_id = B.tax_id;
2493:
2494: CURSOR get_reason IS

Line 3493: , jai_ar_trx_tax_lines a

3489: , b.tax_type tax_type
3490: , SUM(a.tax_amount) tax_amount
3491: FROM
3492: jai_cmn_taxes_all b
3493: , jai_ar_trx_tax_lines a
3494: WHERE a.tax_id = b.tax_id
3495: AND NVL(b.inclusive_tax_flag, 'N') = 'Y'
3496: AND a.link_to_cust_trx_line_id IN (SELECT
3497: customer_trx_line_id