APPS.JAI_PA_BILLING_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 397: jai_regime_tax_types_v c

393: select
394: nvl( sum( decode( nvl(c.regime_code,'XX'), 'VAT', 1, 0)), 0) vat_cnt,
395: nvl( sum( decode( upper(b.tax_type), 'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 0)), 0) excise_cnt
396: from jai_cmn_document_taxes b,
397: jai_regime_tax_types_v c
398: where b.source_doc_type = jai_pa_billing_pkg.gv_source_projects
399: and b.tax_type = c.tax_type(+)
400: and b.source_doc_id = cp_draft_invoice_id;
401:

Line 1697: from jai_regime_tax_types_v

1693: cursor c_get_rgm_for_tax_type (cpv_tax_type varchar2)
1694: is
1695: select regime_code
1696: ,regime_id
1697: from jai_regime_tax_types_v
1698: where tax_type = cpv_tax_type;
1699:
1700: r_regime c_get_rgm_for_tax_type%rowtype;
1701: