DBA Data[Home] [Help]

APPS.JAI_ETCS_PKG dependencies on JAI_RGM_TAXES

Line 2281: from jai_rgm_taxes

2277:
2278: cursor c_tax_amount(cp_tax_type in varchar2, cp_source_doc_id in number, cp_check_id in number)
2279: is
2280: select nvl(sum(tax_amt),0)
2281: from jai_rgm_taxes
2282: where tax_type = cp_tax_type
2283: and trx_ref_id in
2284: ( select trx_ref_id
2285: from jai_rgm_refs_all jra

Line 2437: jai_rgm_taxes jrt,

2433: fnd_global.login_id
2434: from
2435: jai_ap_rgm_payments jrp,
2436: jai_rgm_refs_all jra,
2437: jai_rgm_taxes jrt,
2438: jai_rgm_certificates jrc
2439: where
2440: jrp.settlement_id = jra.settlement_id and
2441: jrp.tax_authority_id = p_tax_authority_id and