DBA Data[Home] [Help]

APPS.JAI_ETCS_PKG dependencies on JAI_RGM_TAXES

Line 1850: from jai_rgm_taxes

1846:
1847: cursor c_tax_amount(cp_tax_type in varchar2, cp_source_doc_id in number, cp_check_id in number)
1848: is
1849: select nvl(sum(tax_amt),0)
1850: from jai_rgm_taxes
1851: where tax_type = cp_tax_type
1852: and trx_ref_id in
1853: ( select trx_ref_id
1854: from jai_rgm_refs_all jra

Line 2006: jai_rgm_taxes jrt,

2002: fnd_global.login_id
2003: from
2004: jai_ap_rgm_payments jrp,
2005: jai_rgm_refs_all jra,
2006: jai_rgm_taxes jrt,
2007: jai_rgm_certificates jrc
2008: where
2009: jrp.settlement_id = jra.settlement_id and
2010: jrp.tax_authority_id = p_tax_authority_id and