APPS.JA_JAINARE1_XMLP_PKG dependencies on JAI_OM_OE_BOND_TRXS

Line 375: CURSOR C_GET_BALANCES(CP_TRANSACTION_NAME IN JAI_OM_OE_BOND_TRXS.TRANSACTION_NAME%TYPE) IS

371: ,ORDER_LINE_ID IN NUMBER
372: ,CUSTOMER_TRX_ID IN NUMBER
373: ,DELIVERY_ID IN NUMBER
374: ,TRX_NUMBER IN VARCHAR2) RETURN NUMBER IS
375: CURSOR C_GET_BALANCES(CP_TRANSACTION_NAME IN JAI_OM_OE_BOND_TRXS.TRANSACTION_NAME%TYPE) IS
376: SELECT
377: ( NVL(TRANSACTION_AMOUNT
378: ,0) + NVL(EDU_CESS_AMOUNT
379: ,0) + NVL(RG23D_REGISTER_BALANCE

Line 390: JAI_OM_OE_BOND_TRXS

386: ,0) + NVL(REGISTER_BALANCE
387: ,0) + NVL(SH_CESS_AMOUNT
388: ,0) ) OPENING_BAL
389: FROM
390: JAI_OM_OE_BOND_TRXS
391: WHERE TRANSACTION_NAME = CP_TRANSACTION_NAME
392: AND ORDER_HEADER_ID = CF_BALANCESFORMULA.ORDER_HEADER_ID
393: AND ORDER_FLAG = 'Y'
394: AND TRANSACTION_ID = (

Line 398: JAI_OM_OE_BOND_TRXS

394: AND TRANSACTION_ID = (
395: SELECT
396: MAX(TRANSACTION_ID)
397: FROM
398: JAI_OM_OE_BOND_TRXS
399: WHERE TRANSACTION_NAME = CP_TRANSACTION_NAME
400: AND ORDER_HEADER_ID = CF_BALANCESFORMULA.ORDER_HEADER_ID
401: AND ORDER_FLAG = 'Y' );
402: BEGIN