APPS.JAI_CMN_BOND_REGISTER_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

select  hdr.register_id ,
        bond_number ,hdr.register_code
from    JAI_OM_OE_BOND_REG_HDRS  hdr,
        JAI_OM_OE_BOND_REG_DTLS   dtl
where   hdr.register_id = dtl.register_id
and     hdr.organization_id = p_organization_id
and     hdr.location_id = p_location_id
and     dtl.order_flag  = p_order_invoice_type
and     dtl.order_type_id = p_order_invoice_id;

Line: 75

select  hdr.register_id ,
        hdr.bond_expiry_date, hdr.lou_flag , register_code
from    JAI_OM_OE_BOND_REG_HDRS  hdr
where   hdr.register_id = p_register_id;

Line: 81

Select   register_balance
from     JAI_OM_OE_BOND_TRXS
where    register_id = p_register_id
and      transaction_id =
(select  max(transaction_id)
  from   JAI_OM_OE_BOND_TRXS
  where register_id = p_register_id
);

Line: 91

Select   RG23D_REGISTER_BALANCE
from     JAI_OM_OE_BOND_TRXS
where    register_id = p_register_id
and      transaction_id =
(select  max(transaction_id)
  from   JAI_OM_OE_BOND_TRXS
  where register_id = p_register_id
);