APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 134: register_id in (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS

130: SELECT register_code
131: FROM JAI_OM_OE_BOND_REG_HDRS
132: WHERE organization_id = p_org_id AND
133: location_id = p_loc_id AND
134: register_id in (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
135: WHERE order_type_id = p_batch_source_id and order_flag ='N');
136: CURSOR excise_cal_cur(p_line_id IN NUMBER, p_inventory_item_id IN NUMBER,
137: p_org_id IN NUMBER) IS
138: select A.tax_id,