APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_DOC_SEQUENCE_CATEGORIES

Line 3154: l_token := 'WSH_DOC_SEQUENCE_CATEGORIES';

3150: END ;
3151:
3152:
3153: BEGIN
3154: l_token := 'WSH_DOC_SEQUENCE_CATEGORIES';
3155: IF l_debug_on THEN
3156: wsh_debug_sv.LOG(l_module_name, 'Validating records in table', l_token);
3157: END IF;
3158: v_delete_permitted := NULL;

Line 3161: FROM WSH_DOC_SEQUENCE_CATEGORIES WDO, WSH_LOCATIONS WSH

3157: END IF;
3158: v_delete_permitted := NULL;
3159: SELECT 'N'
3160: INTO v_delete_permitted
3161: FROM WSH_DOC_SEQUENCE_CATEGORIES WDO, WSH_LOCATIONS WSH
3162: WHERE WDO.LOCATION_ID = P_LOCATION_ID
3163: AND WSH.WSH_LOCATION_ID = WDO.LOCATION_ID
3164: AND WSH.LOCATION_SOURCE_CODE = 'HR'
3165: AND ROWNUM = 1;