DBA Data[Home] [Help]

APPS.JAI_BOE_MIGRATION_PKG dependencies on JAI_REGIME_TAX_TYPES_V

Line 1245: jai_regime_tax_types_v rttv

1241: rttv.regime_code
1242: FROM jai_cmn_tax_ctgs_all jitc,
1243: jai_cmn_tax_ctg_lines jctl,
1244: jai_cmn_taxes_all b,
1245: jai_regime_tax_types_v rttv
1246: WHERE jitc.tax_category_id = jctl.tax_category_id
1247: AND jctl.tax_id = b.tax_id
1248: AND rttv.tax_type = b.tax_type
1249: AND jitc.tax_category_id = ln_tax_category_id;

Line 1258: jai_regime_tax_types_v rttv

1254: COUNT(jctl.tax_id) cnt_tax_id
1255: FROM jai_cmn_tax_ctgs_all jitc,
1256: jai_cmn_tax_ctg_lines jctl,
1257: jai_cmn_taxes_all b,
1258: jai_regime_tax_types_v rttv
1259: WHERE jitc.tax_category_id = jctl.tax_category_id
1260: AND jctl.tax_id = b.tax_id
1261: AND rttv.tax_type = b.tax_type
1262: AND rttv.regime_code = jai_constants.customs_regime