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.

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_CMN_TAXES_ALL

Line 166: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;

162: , p_process_message out nocopy varchar2
163: )
164: is
165:
166: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
167: ln_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;
168: ln_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
169:
170: cursor c_get_surcharge_taxes (cp_tax_type JAI_CMN_TAXES_ALL.tax_type%type

Line 167: ln_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;

163: )
164: is
165:
166: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
167: ln_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;
168: ln_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
169:
170: cursor c_get_surcharge_taxes (cp_tax_type JAI_CMN_TAXES_ALL.tax_type%type
171: ,cp_line_no number default null

Line 168: ln_tax_id JAI_CMN_TAXES_ALL.tax_id%type;

164: is
165:
166: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
167: ln_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;
168: ln_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
169:
170: cursor c_get_surcharge_taxes (cp_tax_type JAI_CMN_TAXES_ALL.tax_type%type
171: ,cp_line_no number default null
172: )

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

166: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
167: ln_rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type;
168: ln_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
169:
170: cursor c_get_surcharge_taxes (cp_tax_type JAI_CMN_TAXES_ALL.tax_type%type
171: ,cp_line_no number default null
172: )
173: is
174: select tax.tax_rate

Line 178: from JAI_CMN_TAXES_ALL tax

174: select tax.tax_rate
175: , tax.rounding_factor
176: , tax.tax_id
177: , cat.line_no
178: from JAI_CMN_TAXES_ALL tax
179: ,JAI_CMN_TAX_CTG_LINES cat
180: where cat.tax_id = tax.tax_id
181: and cat.tax_category_id = p_threshold_tax_cat_id
182: and tax.tax_type = cp_tax_type

Line 1457: , JAI_CMN_TAXES_ALL tax

1453: from jai_rgm_taxes rtax
1454: , jai_rgm_refs_all refs
1455: , JAI_CMN_TAX_CTG_LINES srch
1456: , JAI_CMN_TAX_CTG_LINES srchcess
1457: , JAI_CMN_TAXES_ALL tax
1458: where rtax.trx_ref_id = refs.trx_ref_id
1459: and rtax.tax_type = jai_constants.tax_type_tcs_cess
1460: and srch.tax_category_id = cp_thhold_tax_cat_id
1461: and srchcess.tax_category_id = srch.tax_category_id

Line 1477: , JAI_CMN_TAXES_ALL tax

1473: from jai_rgm_taxes rtax
1474: , jai_rgm_refs_all refs
1475: , JAI_CMN_TAX_CTG_LINES srch
1476: , JAI_CMN_TAX_CTG_LINES srchcess
1477: , JAI_CMN_TAXES_ALL tax
1478: where rtax.trx_ref_id = refs.trx_ref_id
1479: and rtax.tax_type = jai_constants.tax_type_sh_tcs_edu_cess
1480: and srch.tax_category_id = cp_thhold_tax_cat_id
1481: and srchcess.tax_category_id = srch.tax_category_id