APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on MTL_PARAMETERS

Line 49: from mtl_parameters

45: IS
46: cursor wh_flag_cur IS
47: select carrier_manifesting_flag,
48: distributed_organization_flag
49: from mtl_parameters
50: where organization_id= p_organization_id;
51:
52: cursor valid_carrier_det_cur is
53: select distinct wc.manifesting_enabled_flag

Line 555: select organization_code into l_org_code from mtl_parameters where organization_id = l_txn_hist_record.Trading_Partner_ID;

551: ELSIF (instrb(l_Event_Key,'TW2') <> 0) THEN
552: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY');
553: FND_MESSAGE.SET_TOKEN('BATCH_NAME', l_del_name);
554: l_subject := FND_MESSAGE.get;
555: select organization_code into l_org_code from mtl_parameters where organization_id = l_txn_hist_record.Trading_Partner_ID;
556: FND_MESSAGE.SET_NAME('WSH', 'WSH_SR_BATCH_NOTIFY_BODY');
557: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_org_code);
558: FND_MESSAGE.SET_TOKEN('ITEM_KEY', l_Event_Key);
559: l_body_text := FND_MESSAGE.get;