DBA Data[Home] [Help]

APPS.JA_JAINARE1_XMLP_PKG dependencies on JAI_CMN_TAXES_ALL

Line 118: JAI_CMN_TAXES_ALL JTC,

114: CURSOR C_EXCISE_RATE(P_DELIVERY_ID IN NUMBER,P_INVENTORY_ITEM_ID IN NUMBER) IS
115: SELECT
116: JISPTL.TAX_RATE
117: FROM
118: JAI_CMN_TAXES_ALL JTC,
119: JAI_OM_WSH_LINE_TAXES JISPTL
120: WHERE JISPTL.DELIVERY_DETAIL_ID in (
121: SELECT
122: DELIVERY_DETAIL_ID

Line 275: JAI_CMN_TAXES_ALL JTC,

271: ,'EXCISE_SH_EDU_CESS'
272: ,JISPTL.FUNC_TAX_AMOUNT
273: ,0)) EXCISE_SH_CESS
274: FROM
275: JAI_CMN_TAXES_ALL JTC,
276: JAI_OM_WSH_LINE_TAXES JISPTL
277: WHERE JISPTL.DELIVERY_DETAIL_ID in (
278: SELECT
279: DELIVERY_DETAIL_ID