DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 539: FROM jai_ar_trx_tax_lines jattl

535: AND jcta.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS');
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

Line 598: FROM jai_ar_trx_tax_lines jattl

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,
597: jattl.customer_trx_line_id
598: FROM jai_ar_trx_tax_lines jattl
599: , ra_customer_trx_lines_all trxl
600: , jai_cmn_taxes_all jcta
601: WHERE jattl.link_to_cust_trx_line_id = pn_line_number
602: AND trxl.customer_trx_id = pn_invoice_id