1915: WHERE trx_number = v_parent_trx_number;
1916:
1917: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1918: SELECT NVL(register_balance, 0) register_balance
1919: FROM JAI_OM_OE_BOND_TRXS
1920: WHERE transaction_id =
1921: (SELECT MAX(A.transaction_id)
1922: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1923: WHERE A.register_id = B.register_id
1918: SELECT NVL(register_balance, 0) register_balance
1919: FROM JAI_OM_OE_BOND_TRXS
1920: WHERE transaction_id =
1921: (SELECT MAX(A.transaction_id)
1922: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1923: WHERE A.register_id = B.register_id
1924: AND B.organization_id = p_org_id
1925: AND B.location_id = p_loc_id);
1926:
1925: AND B.location_id = p_loc_id);
1926:
1927: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1928: SELECT NVL(rg23d_register_balance, 0) rg23d_register_balance
1929: FROM JAI_OM_OE_BOND_TRXS
1930: WHERE transaction_id =
1931: (SELECT MAX(A.transaction_id)
1932: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1933: WHERE A.register_id = B.register_id
1928: SELECT NVL(rg23d_register_balance, 0) rg23d_register_balance
1929: FROM JAI_OM_OE_BOND_TRXS
1930: WHERE transaction_id =
1931: (SELECT MAX(A.transaction_id)
1932: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1933: WHERE A.register_id = B.register_id
1934: AND B.organization_id = p_org_id
1935: AND B.location_id = p_loc_id);
1936: