DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_AR_TRX_LINES

Line 1446: FROM JAI_AR_TRX_LINES

1442: --Start Addition by anujsax for Bug#5636544
1443: CURSOR cur_excise_invoice_number(cp_customer_trx_id NUMBER)
1444: IS
1445: SELECT excise_invoice_no
1446: FROM JAI_AR_TRX_LINES
1447: WHERE customer_trx_id = cp_customer_trx_id
1448: AND excise_invoice_no is NOT NULL;
1449:
1450: r_excise_invoice_number cur_excise_invoice_number%ROWTYPE;

Line 3499: jai_ar_trx_lines

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
3498: FROM
3499: jai_ar_trx_lines
3500: WHERE customer_trx_id = pn_customer_trx_id)
3501: GROUP BY
3502: a.tax_id
3503: , b.tax_type;