APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 311: FROM jai_ar_trx_tax_lines jrtf_tax,

307: AND rctgl.customer_trx_id = jict1.customer_trx_id
308: AND rt1.complete_flag = 'Y'
309: AND rctgl.account_class = 'REV'
310: AND EXISTS (SELECT 1
311: FROM jai_ar_trx_tax_lines jrtf_tax,
312: jai_cmn_taxes_all jcta
313: WHERE
314: jatl1.customer_trx_line_id = jrtf_tax.link_to_cust_trx_line_id
315: AND jcta.tax_id = jrtf_tax.tax_id

Line 471: FROM jai_ar_trx_tax_lines jrtf,

467: AND apply_date<= cd_reversal_date;
468:
469: CURSOR c_ar_rc_st_amount(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_reversal_date DATE) IS
470: SELECT jcta.mod_cr_percentage, jrtf.tax_amount
471: FROM jai_ar_trx_tax_lines jrtf,
472: jai_ar_trx_lines jatl,
473: jai_cmn_taxes_all jcta,
474: ra_cust_trx_line_gl_dist_all rctgl
475: WHERE jatl.customer_trx_id = cp_invoice_id