DBA Data[Home] [Help]

APPS.FTE_SERVICES_UI_WRAPPER dependencies on WSH_REGIONS_TL

Line 501: FROM wsh_regions_tl

497:
498: BEGIN
499: SELECT postal_code_from, postal_code_to
500: INTO l_postal_code_from, l_postal_code_to
501: FROM wsh_regions_tl
502: WHERE region_id = l_lane_tbl(i).origin_id
503: AND language = USERENV('LANG');
504: EXCEPTION
505: WHEN OTHERS THEN

Line 544: FROM wsh_regions_tl

540:
541: BEGIN
542: SELECT postal_code_from, postal_code_to
543: INTO l_postal_code_from, l_postal_code_to
544: FROM wsh_regions_tl
545: WHERE region_id = l_lane_tbl(i).destination_id
546: AND language = USERENV('LANG');
547: EXCEPTION
548: WHEN OTHERS THEN