APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 268: ,JAI_CMN_TAX_CTG_LINES cat

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

Line 1227: from JAI_OM_WSH_LINE_TAXES line, JAI_CMN_TAX_CTG_LINES cat

1223: declare
1224: cursor c_chk_picking_tax_exists
1225: is
1226: select 1
1227: from JAI_OM_WSH_LINE_TAXES line, JAI_CMN_TAX_CTG_LINES cat
1228: where line.tax_id = cat.tax_id
1229: and line.delivery_detail_id = p_source_trx_line_id
1230: and cat.tax_category_id = p_threshold_tax_cat_id;
1231: begin

Line 1243: from JAI_AR_TRX_TAX_LINES line, JAI_CMN_TAX_CTG_LINES cat

1239: declare
1240: cursor c_chk_ra_trx_tax_exists
1241: is
1242: select 1
1243: from JAI_AR_TRX_TAX_LINES line, JAI_CMN_TAX_CTG_LINES cat
1244: where line.tax_id = cat.tax_id
1245: and line.link_to_cust_trx_line_id = p_source_trx_line_id
1246: and cat.tax_category_id = p_threshold_tax_cat_id;
1247: begin

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

1261: end if;
1262:
1263: --for r_taxes in c_get_taxes_from_category
1264: jai_cmn_tax_defaultation_pkg.get_tax_cat_taxes_cur
1265: (p_tax_category_id => -1 -- pass the value which never exists in JAI_CMN_TAX_CTG_LINES
1266: ,p_threshold_tax_cat_id => p_threshold_tax_cat_id
1267: ,p_max_tax_line => p_last_line_number
1268: ,p_max_rgm_tax_line => p_tax_base_line_number
1269: ,p_base => 0--p_last_line_number/*bduvarag for the bug#6081966, FP of 6084563*/

Line 1554: , JAI_CMN_TAX_CTG_LINES srch

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

Line 1555: , JAI_CMN_TAX_CTG_LINES srchcess

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

Line 1574: , JAI_CMN_TAX_CTG_LINES srch

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

Line 1575: , JAI_CMN_TAX_CTG_LINES srchcess

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