DBA Data[Home] [Help]

APPS.JA_JAINRG1_XMLP_PKG dependencies on JAI_OM_WSH_LINE_TAXES

Line 419: JAI_OM_WSH_LINE_TAXES JSPTL,

415: SELECT
416: JSPTL.TAX_RATE CESS_RATE
417: FROM
418: JAI_OM_WSH_LINES_ALL JSPL,
419: JAI_OM_WSH_LINE_TAXES JSPTL,
420: JAI_CMN_TAXES_ALL JTC
421: WHERE JSPL.DELIVERY_DETAIL_ID = JSPTL.DELIVERY_DETAIL_ID
422: AND JSPTL.TAX_ID = JTC.TAX_ID
423: AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' )

Line 509: JAI_OM_WSH_LINE_TAXES JSPTL,

505: SELECT
506: JSPTL.TAX_RATE CESS_RATE
507: FROM
508: JAI_OM_WSH_LINES_ALL JSPL,
509: JAI_OM_WSH_LINE_TAXES JSPTL,
510: JAI_CMN_TAXES_ALL JTC
511: WHERE JSPL.DELIVERY_DETAIL_ID = JSPTL.DELIVERY_DETAIL_ID
512: AND JSPTL.TAX_ID = JTC.TAX_ID
513: AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' )