DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 474: from JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b

470: a.precedence_10 p_10,
471: b.tax_rate, b.tax_amount, b.uom_code, b.end_date valid_date,
472: -- DECODE(UPPER(b.tax_type), 'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD', 1, jai_constants.tax_type_exc_edu_cess,1, 'TDS', 2, 0) tax_type_val,
473: b.mod_cr_percentage, b.vendor_id, b.tax_type, nvl(b.rounding_factor,0) rounding_factor
474: from JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b
475: WHERE a.tax_category_id = p_tax_category_id
476: AND a.tax_id = b.tax_id
477: ORDER BY a.line_no;
478: