APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 3112: l_token := 'WSH_CALENDAR_ASSIGNMENTS';

3108: END IF;
3109: END ;
3110:
3111: BEGIN
3112: l_token := 'WSH_CALENDAR_ASSIGNMENTS';
3113: IF l_debug_on THEN
3114: wsh_debug_sv.LOG(l_module_name, 'Validating records in table', l_token);
3115: END IF;
3116: v_delete_permitted := NULL;

Line 3119: FROM WSH_CALENDAR_ASSIGNMENTS WCA, WSH_LOCATIONS WSH

3115: END IF;
3116: v_delete_permitted := NULL;
3117: SELECT 'N'
3118: INTO v_delete_permitted
3119: FROM WSH_CALENDAR_ASSIGNMENTS WCA, WSH_LOCATIONS WSH
3120: WHERE WCA.LOCATION_ID = P_LOCATION_ID
3121: AND WSH.WSH_LOCATION_ID = WCA.LOCATION_ID
3122: AND WSH.LOCATION_SOURCE_CODE = 'HR'
3123: AND ROWNUM = 1;