APPS.JA_JAINMCEN_XMLP_PKG dependencies on JAI_RCV_LINE_TAXES

Line 148: JAI_RCV_LINE_TAXES RTL,

144: JTC.ADHOC_FLAG
145: FROM
146: JAI_CMN_RG_23AC_II_TRXS RG23,
147: RCV_TRANSACTIONS RT,
148: JAI_RCV_LINE_TAXES RTL,
149: JAI_CMN_TAXES_ALL JTC
150: WHERE RG23.EXCISE_INVOICE_NO = cf_assessable_valueformula.EXCISE_INVOICE_NO
151: AND RG23.EXCISE_INVOICE_DATE = cf_assessable_valueformula.EXCISE_INVOICE_DATE
152: AND RG23.ORGANIZATION_ID = cf_assessable_valueformula.ORGANIZATION_ID

Line 209: JAI_RCV_LINE_TAXES JRL,

205: CURSOR COUNT_EXCISE_TAXES(CP_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE) IS
206: SELECT
207: COUNT(1)
208: FROM
209: JAI_RCV_LINE_TAXES JRL,
210: RCV_TRANSACTIONS RCVT
211: WHERE RCVT.TRANSACTION_ID = TO_NUMBER(CP_RECEIPT_ID)
212: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE
213: AND RCVT.SHIPMENT_LINE_ID = JRL.SHIPMENT_LINE_ID

Line 219: JAI_RCV_LINE_TAXES JRL,

215: CURSOR COUNT_CVD_TAXES(CP_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE) IS
216: SELECT
217: COUNT(1)
218: FROM
219: JAI_RCV_LINE_TAXES JRL,
220: RCV_TRANSACTIONS RCVT
221: WHERE RCVT.TRANSACTION_ID = TO_NUMBER(CP_RECEIPT_ID)
222: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE
223: AND RCVT.SHIPMENT_LINE_ID = JRL.SHIPMENT_LINE_ID