[Home] [Help]
5649: FROM JAI_OM_OE_BOND_REG_HDRS
5650: WHERE organization_id = p_org_id
5651: AND location_id = p_loc_id
5652: AND register_id IN (SELECT register_id
5653: FROM JAI_OM_OE_BOND_REG_DTLS
5654: WHERE order_type_id = p_batch_source_id
5655: AND order_flag = 'N');
5656:
5657: CURSOR cur_chk_rgm(cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS