DBA Data[Home] [Help]

APPS.JAI_AR_TRXS_PKG dependencies on JAI_OM_OE_BOND_REG_HDRS

Line 141: FROM JAI_OM_OE_BOND_REG_HDRS

137: WHERE organization_id = p_org_id AND
138: location_id = p_loc_id;
139: Cursor register_code_cur(p_org_id IN Number, p_loc_id IN Number, p_batch_source_id IN NUMBER) IS
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');