APPS.JAI_OPEN_API_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 5659: FROM jai_regime_tax_types_v jrttv

5655: AND order_flag = 'N');
5656:
5657: CURSOR cur_chk_rgm(cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
5658: SELECT regime_id, regime_code
5659: FROM jai_regime_tax_types_v jrttv
5660: WHERE upper(jrttv.tax_type) = upper(cp_tax_type);
5661:
5662: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
5663: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

Line 8825: , jai_regime_tax_types_v rttv

8821: ,a.qty_rate --Added by zhiwei for Bug#12604133 on 20110623
8822: ,b.vat_flag --Added by zhiwei for Bug#12604133 on 20110623
8823: from $$TAX_SOURCE_TABLE$$ a
8824: , JAI_CMN_TAXES_ALL b
8825: , jai_regime_tax_types_v rttv
8826: where $$SOURCE_TABLE_FILTER$$
8827: and rttv.tax_type (+) = b.tax_type
8828: and a.tax_id = b.tax_id $$ADDITIONAL_WHERE_CLAUSE$$
8829: order by a.tax_line_no $$ADDITIONAL_ORDER_BY$$';