DBA Data[Home] [Help]

APPS.FTE_TL_RATING dependencies on WSH_GLOBAL_PARAMETERS

Line 544: FROM wsh_new_deliveries wd, wsh_global_parameters wgp

540: -- count the number of deliveries which should not be rated due to freight term
541: CURSOR c_check_trip_freight_term(c_trip_id IN NUMBER)
542: IS
543: SELECT count(wd.delivery_id)
544: FROM wsh_new_deliveries wd, wsh_global_parameters wgp
545: WHERE (
546: ((wd.shipment_direction in ('I'))
547: and (wgp.rate_ib_dels_fgt_term is not null)
548: and (wd.freight_terms_code is not null)

Line 602: FROM wsh_new_deliveries wd, wsh_global_parameters wgp

598: -- count the number of deliveries which should not be rated due to freight term
599: CURSOR c_check_move_freight_term(c_move_id IN NUMBER)
600: IS
601: SELECT count(wd.delivery_id)
602: FROM wsh_new_deliveries wd, wsh_global_parameters wgp
603: WHERE (
604: ((wd.shipment_direction in ('I'))
605: and (wgp.rate_ib_dels_fgt_term is not null)
606: and (wd.freight_terms_code is not null)