eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_CMN_TAXES_ALL

Line 255: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;

251: , p_process_message out nocopy varchar2
252: )
253: is
254:
255: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
256: ln_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;
257: ln_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
258:
259: cursor c_get_surcharge_taxes (cp_tax_type JAI_CMN_TAXES_ALL.tax_type%type

Line 256: ln_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;

252: )
253: is
254:
255: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
256: ln_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;
257: ln_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
258:
259: cursor c_get_surcharge_taxes (cp_tax_type JAI_CMN_TAXES_ALL.tax_type%type
260: ,cp_line_no number default null

Line 257: ln_tax_id JAI_CMN_TAXES_ALL.tax_id%type;

253: is
254:
255: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
256: ln_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;
257: ln_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
258:
259: cursor c_get_surcharge_taxes (cp_tax_type JAI_CMN_TAXES_ALL.tax_type%type
260: ,cp_line_no number default null
261: )

Line 259: cursor c_get_surcharge_taxes (cp_tax_type JAI_CMN_TAXES_ALL.tax_type%type

255: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
256: ln_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;
257: ln_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
258:
259: cursor c_get_surcharge_taxes (cp_tax_type JAI_CMN_TAXES_ALL.tax_type%type
260: ,cp_line_no number default null
261: )
262: is
263: select tax.tax_rate

Line 267: from JAI_CMN_TAXES_ALL tax

263: select tax.tax_rate
264: , tax.rounding_factor
265: , tax.tax_id
266: , cat.line_no
267: from JAI_CMN_TAXES_ALL tax
268: ,JAI_CMN_TAX_CTG_LINES cat
269: where cat.tax_id = tax.tax_id
270: and cat.tax_category_id = p_threshold_tax_cat_id
271: and tax.tax_type = cp_tax_type

Line 1556: , JAI_CMN_TAXES_ALL tax

1552: from jai_rgm_taxes rtax
1553: , jai_rgm_refs_all refs
1554: , JAI_CMN_TAX_CTG_LINES srch
1555: , JAI_CMN_TAX_CTG_LINES srchcess
1556: , JAI_CMN_TAXES_ALL tax
1557: where rtax.trx_ref_id = refs.trx_ref_id
1558: and rtax.tax_type = jai_constants.tax_type_tcs_cess
1559: and srch.tax_category_id = cp_thhold_tax_cat_id
1560: and srchcess.tax_category_id = srch.tax_category_id

Line 1576: , JAI_CMN_TAXES_ALL tax

1572: from jai_rgm_taxes rtax
1573: , jai_rgm_refs_all refs
1574: , JAI_CMN_TAX_CTG_LINES srch
1575: , JAI_CMN_TAX_CTG_LINES srchcess
1576: , JAI_CMN_TAXES_ALL tax
1577: where rtax.trx_ref_id = refs.trx_ref_id
1578: and rtax.tax_type = jai_constants.tax_type_sh_tcs_edu_cess
1579: and srch.tax_category_id = cp_thhold_tax_cat_id
1580: and srchcess.tax_category_id = srch.tax_category_id