APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_AR_TRX_LINES

Line 540: , jai_ar_trx_lines jatl

536:
537: CURSOR get_total_arrec_amt_cur IS
538: SELECT SUM(jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100) tax_amt
539: FROM jai_ar_trx_tax_lines jattl
540: , jai_ar_trx_lines jatl
541: , jai_cmn_taxes_all jcta
542: WHERE jatl.customer_trx_id = pn_invoice_id
543: AND jattl.link_to_cust_trx_line_id = jatl.customer_trx_line_id
544: AND jattl.tax_id = jcta.tax_id

Line 592: FROM jai_ar_trx_lines

588: AND line_type_lookup_code IN ('ITEM', 'MISCELLANEOUS');
589:
590: CURSOR get_total_ar_amt_cur IS
591: SELECT SUM(total_amount)
592: FROM jai_ar_trx_lines
593: WHERE customer_trx_id = pn_invoice_id;
594:
595: CURSOR get_tax_type_ar_cur IS
596: SELECT jcta.tax_type, jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100 tax_amt,