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_TAX_CTG_LINES

Line 179: ,JAI_CMN_TAX_CTG_LINES cat

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
183: and cat.precedence_1 = nvl(cp_line_no, cat.precedence_1); -- This will check that for CESS precedence should be of surcharge

Line 1130: from JAI_OM_WSH_LINE_TAXES line, JAI_CMN_TAX_CTG_LINES cat

1126: declare
1127: cursor c_chk_picking_tax_exists
1128: is
1129: select 1
1130: from JAI_OM_WSH_LINE_TAXES line, JAI_CMN_TAX_CTG_LINES cat
1131: where line.tax_id = cat.tax_id
1132: and line.delivery_detail_id = p_source_trx_line_id
1133: and cat.tax_category_id = p_threshold_tax_cat_id;
1134: begin

Line 1146: from JAI_AR_TRX_TAX_LINES line, JAI_CMN_TAX_CTG_LINES cat

1142: declare
1143: cursor c_chk_ra_trx_tax_exists
1144: is
1145: select 1
1146: from JAI_AR_TRX_TAX_LINES line, JAI_CMN_TAX_CTG_LINES cat
1147: where line.tax_id = cat.tax_id
1148: and line.link_to_cust_trx_line_id = p_source_trx_line_id
1149: and cat.tax_category_id = p_threshold_tax_cat_id;
1150: begin

Line 1168: (p_tax_category_id => -1 -- pass the value which never exists in JAI_CMN_TAX_CTG_LINES

1164: end if;
1165:
1166: --for r_taxes in c_get_taxes_from_category
1167: jai_cmn_tax_defaultation_pkg.get_tax_cat_taxes_cur
1168: (p_tax_category_id => -1 -- pass the value which never exists in JAI_CMN_TAX_CTG_LINES
1169: ,p_threshold_tax_cat_id => p_threshold_tax_cat_id
1170: ,p_max_tax_line => p_last_line_number
1171: ,p_max_rgm_tax_line => p_tax_base_line_number
1172: ,p_base => 0--p_last_line_number/*bduvarag for the bug#6081966, FP of 6084563*/

Line 1455: , JAI_CMN_TAX_CTG_LINES srch

1451: is
1452: select sum(rtax.func_tax_amt)
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

Line 1456: , JAI_CMN_TAX_CTG_LINES srchcess

1452: select sum(rtax.func_tax_amt)
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

Line 1475: , JAI_CMN_TAX_CTG_LINES srch

1471: is
1472: select sum(rtax.func_tax_amt)
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

Line 1476: , JAI_CMN_TAX_CTG_LINES srchcess

1472: select sum(rtax.func_tax_amt)
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