78: where hdr.register_id = p_register_id;
79:
80: Cursor c_get_bond_register_balance is
81: Select register_balance
82: from JAI_OM_OE_BOND_TRXS
83: where register_id = p_register_id
84: and transaction_id =
85: (select max(transaction_id)
86: from JAI_OM_OE_BOND_TRXS
82: from JAI_OM_OE_BOND_TRXS
83: where register_id = p_register_id
84: and transaction_id =
85: (select max(transaction_id)
86: from JAI_OM_OE_BOND_TRXS
87: where register_id = p_register_id
88: );
89:
90: Cursor c_get_other_register_balance is
88: );
89:
90: Cursor c_get_other_register_balance is
91: Select RG23D_REGISTER_BALANCE
92: from JAI_OM_OE_BOND_TRXS
93: where register_id = p_register_id
94: and transaction_id =
95: (select max(transaction_id)
96: from JAI_OM_OE_BOND_TRXS
92: from JAI_OM_OE_BOND_TRXS
93: where register_id = p_register_id
94: and transaction_id =
95: (select max(transaction_id)
96: from JAI_OM_OE_BOND_TRXS
97: where register_id = p_register_id
98: );
99:
100: v_register_id Number;