APPS.JAI_OM_WSH_PKG dependencies on JAI_OM_WSH_LINE_TAXES

Line 242: FROM JAI_OM_WSH_LINE_TAXES A, JAI_CMN_TAXES_ALL b

238: AND b.order_type_id = p_order_type_id ;
239:
240: CURSOR for_modvat_tax_rate(p_delivery_detail_id NUMBER) IS
241: SELECT A.tax_rate, b.rounding_factor
242: FROM JAI_OM_WSH_LINE_TAXES A, JAI_CMN_TAXES_ALL b
243: WHERE A.tax_id = b.tax_id
244: AND A.delivery_detail_id = p_delivery_detail_id
245: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; /* --'Modvat Recovery'; Ramananda for removal of SQL LITERALs */
246:

Line 474: CURSOR c_excise_tax_cnt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.delivery_detail_id%type) IS

470:
471: /* added by bgowrava for forward porting - bug# 5554420 */
472: lv_exc_inv_gen_for_dlry_flag varchar2(1);
473: ln_excise_tax_cnt number;
474: CURSOR c_excise_tax_cnt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.delivery_detail_id%type) IS
475: SELECT count(1)
476: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
477: JAI_CMN_TAXES_ALL JTC
478: WHERE JSPTL.TAX_ID = JTC.TAX_ID

Line 476: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,

472: lv_exc_inv_gen_for_dlry_flag varchar2(1);
473: ln_excise_tax_cnt number;
474: CURSOR c_excise_tax_cnt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.delivery_detail_id%type) IS
475: SELECT count(1)
476: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
477: JAI_CMN_TAXES_ALL JTC
478: WHERE JSPTL.TAX_ID = JTC.TAX_ID
479: AND JSPTL.delivery_detail_id = cp_delivery_detail_id
480: AND upper(jtc.tax_type) like '%EXCISE%';

Line 487: CURSOR c_excise_tax_rate(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS

483: /*
484: || Added by Ramananda
485: || Start of bug#4543424
486: */
487: CURSOR c_excise_tax_rate(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS
488: SELECT SUM(NVL(JSPTL.tax_rate,0)) , count(1) --NVL(sum(JSPTL.tax_rate),0)
489: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
490: JAI_CMN_TAXES_ALL JTC
491: WHERE JSPTL.TAX_ID = JTC.TAX_ID

Line 489: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,

485: || Start of bug#4543424
486: */
487: CURSOR c_excise_tax_rate(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS
488: SELECT SUM(NVL(JSPTL.tax_rate,0)) , count(1) --NVL(sum(JSPTL.tax_rate),0)
489: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
490: JAI_CMN_TAXES_ALL JTC
491: WHERE JSPTL.TAX_ID = JTC.TAX_ID
492: AND JSPTL.delivery_detail_id = cp_delivery_detail_id
493: AND UPPER(JTC.TAX_TYPE) = 'EXCISE';

Line 504: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

500: */
501:
502: CURSOR c_cess_amount (cp_Delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type) is
503: SELECT sum(jsptl.func_tax_amount) tax_amount
504: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
505: JAI_CMN_TAXES_ALL jtc
506: WHERE jtc.tax_id = jsptl.tax_id
507: AND delivery_detail_id in
508: (SELECT delivery_detail_id

Line 518: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

514:
515: /*Cursor added by ssawant for bug 5989740 */
516: CURSOR c_sh_cess_amount (cp_Delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type) is
517: SELECT sum(jsptl.func_tax_amount) tax_amount
518: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
519: JAI_CMN_TAXES_ALL jtc
520: WHERE jtc.tax_id = jsptl.tax_id
521: AND delivery_detail_id in
522: (SELECT delivery_detail_id

Line 549: jai_om_wsh_line_taxes jsptl,

545: SELECT
546: sum(func_tax_amount) cess_amount
547: FROM
548: jai_om_wsh_lines_all jspl ,
549: jai_om_wsh_line_taxes jsptl,
550: jai_cmn_taxes_all jtc
551: WHERE
552: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
553: jsptl.tax_id = jtc.tax_id AND

Line 567: JAI_OM_WSH_LINE_TAXES jsptl,

563: SELECT
564: sum(func_tax_amount) cess_amount
565: FROM
566: JAI_OM_WSH_LINES_ALL jspl,
567: JAI_OM_WSH_LINE_TAXES jsptl,
568: JAI_CMN_TAXES_ALL jtc
569: WHERE
570: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
571: jsptl.tax_id = jtc.tax_id AND