APPS.MST_WB_UTIL dependencies on WSH_CARRIER_SERVICES

Line 1732: FROM wsh_carrier_services wcs,

1728: fnd_message.set_token('DESTINATION_CITY', l_temp);
1729:
1730: SELECT nvl(round(wcs.max_driving_time_in_24hr),0)
1731: INTO l_id2
1732: FROM wsh_carrier_services wcs,
1733: mst_exception_details med
1734: WHERE wcs.carrier_service_id = med.carrier_service_id
1735: AND med.plan_id = P_PLAN_ID
1736: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;

Line 1748: FROM wsh_carrier_services wcs,

1744: fnd_message.set_token('DRIVING_TIME', l_id1);
1745:
1746: SELECT nvl(round(wcs.max_total_time),0)
1747: INTO l_id2
1748: FROM wsh_carrier_services wcs,
1749: mst_exception_details med
1750: WHERE wcs.carrier_service_id = med.carrier_service_id
1751: AND med.plan_id = P_PLAN_ID
1752: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;

Line 1757: FROM wsh_carrier_services wcs,

1753: fnd_message.set_token('MAX_TIME', l_id2);
1754:
1755: SELECT nvl(round(wcs.max_duty_time_in_24hr),0)
1756: INTO l_id2
1757: FROM wsh_carrier_services wcs,
1758: mst_exception_details med
1759: WHERE wcs.carrier_service_id = med.carrier_service_id
1760: AND med.plan_id = P_PLAN_ID
1761: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;

Line 1773: FROM wsh_carrier_services wcs,

1769: fnd_message.set_token('DUTY_TIME', l_id1);
1770:
1771: SELECT nvl(round(wcs.min_layover_time),0)
1772: INTO l_id2
1773: FROM wsh_carrier_services wcs,
1774: mst_exception_details med
1775: WHERE wcs.carrier_service_id = med.carrier_service_id
1776: AND med.plan_id = P_PLAN_ID
1777: AND med.exception_detail_id = P_EXCEPTION_DETAIL_ID;