DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 959: ,JAI_AR_TRX_TAX_LINES jrcttl

955: cursor c_get_ra_line_srvtyp (cp_customer_trx_line_id jai_ar_trx_lines.customer_trx_line_id%type)
956: is
957: select service_type_code, sum(jrcttl.tax_amount) service_tax_amount
958: from JAI_AR_TRX_LINES jrctl
959: ,JAI_AR_TRX_TAX_LINES jrcttl
960: ,jai_cmn_taxes_all jtc
961: where jrctl.customer_trx_line_id = cp_customer_trx_line_id
962: and jrcttl.link_to_cust_trx_line_id = jrctl.customer_trx_line_id
963: and jtc.tax_id = jrcttl.tax_id