DBA Data[Home] [Help]

APPS.JAI_AR_TRXS_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 144: register_id in (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS

140: SELECT register_code
141: FROM JAI_OM_OE_BOND_REG_HDRS
142: WHERE organization_id = p_org_id AND
143: location_id = p_loc_id AND
144: register_id in (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
145: WHERE order_type_id = p_batch_source_id and order_flag ='N');
146: CURSOR excise_cal_cur(p_line_id IN NUMBER, p_inventory_item_id IN NUMBER,
147: p_org_id IN NUMBER) IS
148: select A.tax_id,