APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_TAXES_ALL

Line 247: FROM JAI_OM_WSH_LINE_TAXES A, JAI_CMN_TAXES_ALL b

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

Line 490: JAI_CMN_TAXES_ALL JTC

486: ln_excise_tax_cnt number;
487: CURSOR c_excise_tax_cnt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.delivery_detail_id%type) IS
488: SELECT count(1)
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) like '%EXCISE%';
494:

Line 503: JAI_CMN_TAXES_ALL JTC

499: */
500: CURSOR c_excise_tax_rate(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS
501: SELECT SUM(NVL(JSPTL.tax_rate,0)) , count(1) --NVL(sum(JSPTL.tax_rate),0)
502: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
503: JAI_CMN_TAXES_ALL JTC
504: WHERE JSPTL.TAX_ID = JTC.TAX_ID
505: AND JSPTL.delivery_detail_id = cp_delivery_detail_id
506: AND UPPER(JTC.TAX_TYPE) = 'EXCISE';
507:

Line 508: ln_total_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;

504: WHERE JSPTL.TAX_ID = JTC.TAX_ID
505: AND JSPTL.delivery_detail_id = cp_delivery_detail_id
506: AND UPPER(JTC.TAX_TYPE) = 'EXCISE';
507:
508: ln_total_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
509: ln_number_of_Taxes NUMBER;
510: /*
511: || Added by Ramananda
512: || End of bug#4543424

Line 519: JAI_CMN_TAXES_ALL JTC,

515: /*Start additions by mmurtuza for bug 15971482*/
516: CURSOR c_excise_base_tax_amt(cp_delivery_detail_id JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE) IS
517: SELECT sum(NVL(JSPTL.base_tax_amount,0) / JOWLA.quantity)
518: FROM JAI_OM_WSH_LINE_TAXES JSPTL ,
519: JAI_CMN_TAXES_ALL JTC,
520: JAI_OM_WSH_LINES_ALL JOWLA
521: WHERE JSPTL.TAX_ID = JTC.TAX_ID
522: AND JSPTL.delivery_detail_id = cp_delivery_detail_id
523: AND JSPTL.delivery_detail_id = JOWLA.delivery_detail_id

Line 533: JAI_CMN_TAXES_ALL jtc

529:
530: CURSOR c_cess_amount (cp_Delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type) is
531: SELECT sum(jsptl.func_tax_amount) tax_amount
532: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
533: JAI_CMN_TAXES_ALL jtc
534: WHERE jtc.tax_id = jsptl.tax_id
535: AND delivery_detail_id in
536: (SELECT delivery_detail_id
537: FROM JAI_OM_WSH_LINES_ALL

Line 547: JAI_CMN_TAXES_ALL jtc

543: /*Cursor added by ssawant for bug 5989740 */
544: CURSOR c_sh_cess_amount (cp_Delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type) is
545: SELECT sum(jsptl.func_tax_amount) tax_amount
546: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
547: JAI_CMN_TAXES_ALL jtc
548: WHERE jtc.tax_id = jsptl.tax_id
549: AND delivery_detail_id in
550: (SELECT delivery_detail_id
551: FROM JAI_OM_WSH_LINES_ALL

Line 578: jai_cmn_taxes_all jtc

574: sum(func_tax_amount) cess_amount
575: FROM
576: jai_om_wsh_lines_all jspl ,
577: jai_om_wsh_line_taxes jsptl,
578: jai_cmn_taxes_all jtc
579: WHERE
580: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
581: jsptl.tax_id = jtc.tax_id AND
582: upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) AND

Line 596: JAI_CMN_TAXES_ALL jtc

592: sum(func_tax_amount) cess_amount
593: FROM
594: JAI_OM_WSH_LINES_ALL jspl,
595: JAI_OM_WSH_LINE_TAXES jsptl,
596: JAI_CMN_TAXES_ALL jtc
597: WHERE
598: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
599: jsptl.tax_id = jtc.tax_id AND
600: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,