700: WHERE trx_number = v_parent_trx_number;
701:
702: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
703: SELECT NVL(register_balance,0) register_balance
704: FROM JAI_OM_OE_BOND_TRXS
705: WHERE transaction_id = (SELECT MAX(A.transaction_id)
706: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
707: WHERE A.register_id = B.register_id
708: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
702: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
703: SELECT NVL(register_balance,0) register_balance
704: FROM JAI_OM_OE_BOND_TRXS
705: WHERE transaction_id = (SELECT MAX(A.transaction_id)
706: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
707: WHERE A.register_id = B.register_id
708: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
709:
710: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
708: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
709:
710: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
711: SELECT NVL(rg23d_register_balance,0) rg23d_register_balance
712: FROM JAI_OM_OE_BOND_TRXS
713: WHERE transaction_id = (SELECT MAX(A.transaction_id)
714: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
715: WHERE A.register_id = B.register_id
716: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
710: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
711: SELECT NVL(rg23d_register_balance,0) rg23d_register_balance
712: FROM JAI_OM_OE_BOND_TRXS
713: WHERE transaction_id = (SELECT MAX(A.transaction_id)
714: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
715: WHERE A.register_id = B.register_id
716: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
717:
718: CURSOR line_cur IS